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

From Tom Lane
Subject Re: Compression and on-disk sorting
Date
Msg-id 29905.1148676111@sss.pgh.pa.us
Whole thread Raw
In response to Re: Compression and on-disk sorting  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Compression and on-disk sorting
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Compression and on-disk sorting
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Compression and on-disk sorting