| 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: | 3DD508A1.8DA09511@t1.unisoftbg.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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?
regards.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pginfo | 2002-11-15 15:10:31 | Re: Sort time |
| Previous Message | Andrew Sullivan | 2002-11-15 14:34:59 | Re: [GENERAL] Upgrade to dual processor machine? |