Re: Compression and on-disk sorting - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Compression and on-disk sorting
Date
Msg-id 26799.1148661336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Compression and on-disk sorting
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> Something else worth mentioning is that sort performance is worse with
> larger work_mem for all cases except the old HEAD, prior to the
> tuplesort.c changes. It looks like whatever was done to fix that will
> need to be adjusted/rethought pending the outcome of using compression.

Please clarify.  What are you comparing here exactly, and what cases did
you test?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: LIKE, leading percent, bind parameters and indexes
Next
From: Martijn van Oosterhout
Date:
Subject: Re: LIKE, leading percent, bind parameters and indexes