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

From Artur Rataj
Subject How to get fast ~ operator using C locale
Date
Msg-id b3397f3f0707050444t64645d0cv423fd347333f90e3@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: "E.J. Moloney"
Date:
Subject: Vacuum issue
Next
From: "David F. Johnson"
Date:
Subject: User-Defined Types