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

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 (view raw or flat)
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

pgsql-performance by date

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

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