How to get fast ~ operator using C locale

From: "Artur Rataj" <arturrataj(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get fast ~ operator using C locale
Date: 2007-07-05 11:44:25
Message-ID: b3397f3f0707050444t64645d0cv423fd347333f90e3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I want to have pg use fast indexing for ~ operator. Is setting
C locale for this is still necessary? If yes, is it enough to
initdb/createdb with C locale? If it is not enough, why setting locale
to C and starting postmaster still gives other locale, for example,
pl_PL, in
postmaster log "initial environ dump"?

Best regards,
Artur

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artur Rataj 2007-07-05 11:49:56 How to get fast ~ operator using C locale
Previous Message E.J. Moloney 2007-07-05 11:02:09 Vacuum issue