locale and performance?

From: Daniel Weinand <mail4ng(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: locale and performance?
Date: 2007-07-27 11:00:34
Message-ID: 1185534034.799334.198990@19g2000hsx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
in the documentation is written that there'a a perfomrance impact if
another locale than C or POSIX is used.
problem is that using the standard locale results in unusable order
results for languages with spcial chars. in my example "umlauts" in
german.

it isn't acceptable to use the database without indexes if another
locale is used. are custom operator classes as described in the manual
as high-performance as the native index? are there any examples how to
use them in my case?

are there any tests that show how the performance decreases if another
locale is used? why is there a perfomance impact? it's a disappointing
that postgresql is only in one configuration to suply the max.
performance.

any tips or hints on that?

regards

Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2007-07-27 13:04:41 Re: ssl connections to postgresql
Previous Message Alvaro Herrera 2007-07-27 09:11:03 Re: a few questions (and doubts) about xid