Thread: Re: default locale considered harmful? (was Re: [GENERAL]
On Fri, 6 Jun 2003, Peter Eisentraut wrote: > scott.marlowe writes: > > > If indexes on text worked right in other locales it would be no big deal. > > They will in version 7.4, so all these concerns about trading off locale > use vs. performance will become obsolete. Oh! I thought there were still issues that couldn't be worked out on that front. In that case, heck yeah, set the locale on initdb to the current system locale. sweet.
scott.marlowe wrote: > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > scott.marlowe writes: > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > They will in version 7.4, so all these concerns about trading off locale > > use vs. performance will become obsolete. > > Oh! I thought there were still issues that couldn't be worked out on that > front. In that case, heck yeah, set the locale on initdb to the current > system locale. sweet. The problems go away _if_ the user knows about the new way of indexing LIKE on non-C locales. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
On Fri, 6 Jun 2003, Bruce Momjian wrote: > scott.marlowe wrote: > > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > > > scott.marlowe writes: > > > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > > > They will in version 7.4, so all these concerns about trading off locale > > > use vs. performance will become obsolete. > > > > Oh! I thought there were still issues that couldn't be worked out on that > > front. In that case, heck yeah, set the locale on initdb to the current > > system locale. sweet. > > The problems go away _if_ the user knows about the new way of indexing > LIKE on non-C locales. Should we have something about this mentioned in http://developer.postgresql.org/docs/postgres/install-upgrading.html for the 7.4 release? Or is there a more appropriate place?
scott.marlowe wrote: > On Fri, 6 Jun 2003, Bruce Momjian wrote: > > > scott.marlowe wrote: > > > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > > > > > scott.marlowe writes: > > > > > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > > > > > They will in version 7.4, so all these concerns about trading off locale > > > > use vs. performance will become obsolete. > > > > > > Oh! I thought there were still issues that couldn't be worked out on that > > > front. In that case, heck yeah, set the locale on initdb to the current > > > system locale. sweet. > > > > The problems go away _if_ the user knows about the new way of indexing > > LIKE on non-C locales. > > Should we have something about this mentioned in > > http://developer.postgresql.org/docs/postgres/install-upgrading.html > > for the 7.4 release? Or is there a more appropriate place? Yes, at a minimum, plus we need someone coming fresh to 7.5 to know this is an issue. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073