Re: How to get fast ~ operator using C locale

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Artur Rataj" <arturrataj(at)gmail(dot)com>
Cc: "Dimitri Fontaine" <dfontaine(at)hi-media(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to get fast ~ operator using C locale
Date: 2007-07-05 12:50:37
Message-ID: b42b73150707050550y1fb3b2e4ued20159ab01a287e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/5/07, Artur Rataj <arturrataj(at)gmail(dot)com> wrote:
> But I want the server to use the C locale. I set the locale to C and
> run postmaster. I supposed it uses C locale, but -d 5 shows in log:

The locale for indexing is set during initdb:
initdb --no-locale

The ~ operator does consider using btree regardless of locale unless
your right hand term is a constant and you can reduce to a
(functional) boolean index...so ISTM you are looking in the wrong
place anyways...try tsearch2?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-07-05 12:54:08 Re: How to get fast ~ operator using C locale
Previous Message E.J. Moloney 2007-07-05 12:17:13 Vacuum issue