Re: Minor performance improvement in transition to external sort

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: Minor performance improvement in transition to external sort
Дата
Msg-id 52F54FE0.8040408@wizmail.org
обсуждение исходный текст
Ответ на Re: Minor performance improvement in transition to external sort  (Jeremy Harris <jgh@wizmail.org>)
Ответы Re: Minor performance improvement in transition to external sort  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 06/02/14 22:12, Jeremy Harris wrote:
>>  Did you try sorting already-sorted, reverse
>> sorted, or pipe-organ shaped data sets?

Summary (low numbers better):

Random ints:         83% compares, level on time.
Sorted ints:         level compares, 70% time.
Reverse-sorted ints: 10% compares, 15% time      (!)
Constant ints:       200% compares, 360% time    (ouch, and not O(n))
Pipe-organ ints:     80% compares, 107% time
Random text:         83% compares, 106% time

--
Cheers,
   Jeremy

Вложения

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

Предыдущее
От: "Erik Rijkers"
Дата:
Сообщение: Re: Changeset Extraction v7.5
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Changeset Extraction v7.5