Re: Changing the default configuration - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Changing the default configuration
Date
Msg-id Pine.LNX.4.33.0302121127140.5420-100000@css120.ihs.com
Whole thread Raw
In response to Re: Changing the default configuration  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Changing the default configuration (was Re:
Next
From: Bruce Momjian
Date:
Subject: Re: log_duration