Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> So even in a north-american locale, such as en_CA this will be a
If it's not "C" we won't try to optimize LIKE. I know en_US does not
work (case-insensitive, funny rules about spaces, etc) and I would
expect en_CA has the same issues.
If you're using 7.4 you have the option to create a special index
instead of re-initdb'ing your whole database.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2003-12-19 15:07:15|
|Subject: Re: why do optimizer parameters have to be set manually? |
|Previous:||From: Marinos J. Yannikos||Date: 2003-12-19 13:53:22|
|Subject: Re: why do optimizer parameters have to be set manually?|