Re: Sort time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Rod Taylor <rbt(at)rbt(dot)ca>, pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sort time
Date: 2002-11-15 23:32:53
Message-ID: 2763.1037403173@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pginfo 2002-11-16 06:20:35 Re: Sort time
Previous Message Tom Lane 2002-11-15 23:02:15 ANALYZE and indexes (was Re: Sort time)