Re: problem with large maintenance_work_mem settings and - Mailing list pgsql-hackers

From Tom Lane
Subject Re: problem with large maintenance_work_mem settings and
Date
Msg-id 22094.1142032859@sss.pgh.pa.us
Whole thread Raw
In response to Re: problem with large maintenance_work_mem settings and  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: problem with large maintenance_work_mem settings and  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List 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 by date:

Previous
From: Ragnar
Date:
Subject: Re: Proposal for SYNONYMS
Next
From: "Jaime Casanova"
Date:
Subject: There is a problem with the download site?