Re: Memory usage during sorting

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Memory usage during sorting
Дата
Msg-id CAM-w4HOT2txOZ+nJLjSXDeJzK5h8V5Gm+L7JQoZ_tjcM-U=xjA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Memory usage during sorting  (Peter Geoghegan <peter@2ndquadrant.com>)
Ответы Re: Memory usage during sorting  (Peter Geoghegan <peter@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Apr 13, 2012 at 7:01 PM, Peter Geoghegan <peter@2ndquadrant.com> wrote:
> Well, timsort is specifically designed to take advantage of pre-sorted
> data. It does appear to have a lot of traction, as wikipedia points
> out:

I hadn't heard of it. But reading up on it it does seem like a good
fit for us. It trades some additional storage -- an array of pointers
into the sort array where in our case the pointers would be much
smaller than a whole SortTuple -- for fewer comparisons -- which in
our case are often much slower than a simple integer comparison.

-- 
greg


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Patch: add timing of buffer I/O requests
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: column name of pg_stat_replication.backend_start