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

Re: Sort time

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "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 14:45:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hi Tom,

I use unicode for my db, but the locale is US!
The unicode is only for non english varchar and I do not make any comparation or
sorts or joins based
on non english fields ( all this is made in the client part of the system).

What locale will be fast?
Have you any info about the speed in the faster locale and in INT?


Tom Lane wrote:

> pginfo <pginfo(at)t1(dot)unisoftbg(dot)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

In response to


pgsql-performance by date

Next:From: pginfoDate: 2002-11-15 15:10:31
Subject: Re: Sort time
Previous:From: Andrew SullivanDate: 2002-11-15 14:34:59
Subject: Re: [GENERAL] Upgrade to dual processor machine?

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