Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) - Mailing list pgsql-performance

From Tom Lane
Subject Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour)
Date
Msg-id 27898.1140100960@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] qsort again (was Re: Strange Create Index  ("Gary Doades" <gpd@gpdnet.co.uk>)
Responses Re: [HACKERS] qsort again (was Re: Strange Create Index
List pgsql-performance
Tree view 
"Gary Doades" <gpd@gpdnet.co.uk> writes:
> I think the reason I wasn't seeing performance issues with normal sort
> operations is because they use work_mem not maintenance_work_mem which was
> only set to 2048 anyway. Does that sound right?

Very probable.  Do you want to test the theory by jacking that up?  ;-)

            regards, tom lane

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: qsort again (was Re: Strange Create Index
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [HACKERS] qsort again (was Re: Strange Create Index