Re: Sort performance on large tables

From: Charlie Savage <cfis(at)interserv(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sort performance on large tables
Date: 2005-11-08 23:47:10
Message-ID: dkrddq$22bd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Its an int4.

Charlie

Tom Lane wrote:
> Charlie Savage <cfis(at)interserv(dot)com> writes:
>> Thus the time decreased from 8486 seconds to 5279 seconds - which is a
>> nice improvement. However, that still leaves postgresql about 9 times
>> slower.
>
> BTW, what data type are you sorting, exactly? If it's a string type,
> what is your LC_COLLATE setting?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-11-09 01:49:39 Re: Sort performance on large tables
Previous Message Thomas F. O'Connell 2005-11-08 23:26:28 Re: Figuring out which command failed