Re: problem with large maintenance_work_mem settings and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem with large maintenance_work_mem settings and
Дата
Msg-id 22094.1142032859@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: problem with large maintenance_work_mem settings and  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: problem with large maintenance_work_mem settings and  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-hackers
I wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>> samples  %        symbol name
>> 350318533 98.8618  mergepreread
>> 971822    0.2743  tuplesort_gettuple_common
>> 413674    0.1167  tuplesort_heap_siftup

> I don't have enough memory to really reproduce this, but I've come close
> enough that I believe I see what's happening.  It's an artifact of the
> code I added recently to prevent the SortTuple array from growing during
> the merge phase, specifically the "mergeslotsfree" logic.

I've committed a fix for this; if you're still interested, please
retest.
        regards, tom lane


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

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: Proposal for SYNONYMS
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: There is a problem with the download site?