Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group