Oh, another setting that should be a "default" for most users is to initdb 
automatically with locale of C.  If they need a different locale, they 
should have to pick it.

The performance of Postgresql with a locale other than C when doing like 
and such is a serious ding.  I'd much rather have the user experience the 
faster searches first, then get to test with other locales and see if 
performance is good enough, than to start out slow and wonder why they 
need to change their initdb settings to get decent performance on a where 
clause with like in it.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to