Re: Sort time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sort time
Date
Msg-id 2763.1037403173@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sort time  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Here's a question: is the total size of the column a good indicator of the
> sort_mem required?   Or does the rowsize affect it somehow?

It will include all the data that's supposed to be output by the sort...
both the key column(s) and the others.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: ANALYZE and indexes (was Re: Sort time)
Next
From: pginfo
Date:
Subject: Re: Sort time