Re: Index not used, performance problem

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index not used, performance problem
Date: 2003-03-29 15:34:52
Message-ID: 20030329103452.B16250@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Mar 29, 2003 at 09:47:51PM +0800, Christopher Kings-Lynne wrote:
> the form 'FOO%', which is what you are doing. However, I believe that
> PostgreSQL cannot do this if your database encoding is anything other than
> 'C'. So, if you are using an Austrian encoding, it might not be able to

That is, you need to have had the LOCALE set to 'C' when you did
initdb. It's not enough to change it afterwards.

A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John K. Herreshoff 2003-03-29 16:49:00 Re: Index not used, performance problem
Previous Message Christopher Kings-Lynne 2003-03-29 13:47:51 Re: Index not used, performance problem