Postgres Pro
Downloads
Home   >   mailing lists

Re: Sort time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sort time
Date
Msg-id 27564.1037374273@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sort time  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-performance
Tree view 
pginfo <pginfo@t1.unisoftbg.com> writes:
> It is huge improvement when I sort by INT field, but I need to sort varchar
> fileds !

What locale are you using?  strcoll() comparisons can be awfully slow in
some locales.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] Upgrade to dual processor machine?
Next
From: pginfo
Date:
Subject: Re: Sort time