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? http://www.postgresql.org/users-lounge/docs/faq.html
