Re: How to get fast ~ operator using C locale - Mailing list pgsql-general

From Merlin Moncure
Subject Re: How to get fast ~ operator using C locale
Date
Msg-id b42b73150707050550y1fb3b2e4ued20159ab01a287e@mail.gmail.com
Whole thread Raw
In response to Re: How to get fast ~ operator using C locale  ("Artur Rataj" <arturrataj@gmail.com>)
List pgsql-general
On 7/5/07, Artur Rataj <arturrataj@gmail.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

pgsql-general by date:

Previous
From: "E.J. Moloney"
Date:
Subject: Vacuum issue
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How to get fast ~ operator using C locale