Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Compression and on-disk sorting
Дата
Msg-id 29905.1148676111@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Compression and on-disk sorting
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> There is a noticeable rise in sort time with increasing work_mem, but
> that needs to be offset from the benefit that in-general comes from
> using a large Heap for the sort. With the data you're using that always
> looks like a loss, but that isn't true with all input data orderings.

Yeah, these are all the exact same test data, right?  We need a bit more
variety in the test cases before drawing any sweeping conclusions.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Compression and on-disk sorting
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Compression and on-disk sorting