Re: I: About "Our CLUSTER implementation is pessimal" patch

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: I: About "Our CLUSTER implementation is pessimal" patch
Дата
Msg-id 687719.72142.qm@web29010.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: I: About "Our CLUSTER implementation is pessimal" patch  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Ответы Re: I: About "Our CLUSTER implementation is pessimal" patch  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
> > 10% is nothing.  I was expecting this  patch would give an order of
> > magnitude of improvement or somethine like  that in the worst cases of
> > the current code (highly unsorted  input)
>
> Yes. It should be x10 faster than ordinary method in the worst  cases.


Here's my post with a (very simple) performance test:

http://archives.postgresql.org/pgsql-hackers/2010-02/msg00766.php


The test I used wasn't a "worst case" scenario, since it is based on
random data, not wrong-ordered data. Obviously, the real difference
can be seen on large tables (5M+ rows), and/or slow disks.


Leonardo





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: recovery.conf location
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: operator dependency of commutator and negator