Re: [PERFORM] A Better External Sort?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PERFORM] A Better External Sort?
Дата
Msg-id 4339700A.2030803@agliodbs.com
обсуждение исходный текст
Ответ на Re: [PERFORM] A Better External Sort?  (Ron Peacetree <rjpeace@earthlink.net>)
Список pgsql-hackers
Ron,

I've somehow missed part of this thread, which is a shame since this is
an area of primary concern for me.

Your suggested algorithm seems to be designed to relieve I/O load by
making more use of the CPU.   (if I followed it correctly).  However,
that's not PostgreSQL's problem; currently for us external sort is a
*CPU-bound* operation, half of which is value comparisons.  (oprofiles
available if anyone cares)

So we need to look, instead, at algorithms which make better use of
work_mem to lower CPU activity, possibly even at the expense of I/O.

--Josh Berkus

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Database file compatability
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Making pgxs builds work with a relocated installation