| From: | Matthew Gabeler-Lee <mgabelerlee(at)zycos(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.3 no longer using indexes for LIKE queries |
| Date: | 2002-12-04 00:41:12 |
| Message-ID: | ABABFB80F35AD311848B0090279918EF010B9B60@ZYCOSNT2.hq.zycos.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks, it did it in en_US ... This seems like it should be a fixable thing
to me
* decides to do his day long database dump/restore tomorrow ...
-Matt
-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)com]
Sent: Tuesday, December 03, 2002 19:29
To: Matthew Gabeler-Lee
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] 7.3 no longer using indexes for LIKE queries
Did you perhaps not initdb in "C" locale? I think pg_controldata will
tell you what it was created with. The optimization for converting
anchored likes into an indexable form doesn't work in all locales and is
currently only done in C locale I believe.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2002-12-04 00:43:36 | performance tuning |
| Previous Message | Joe Conway | 2002-12-04 00:30:51 | Re: 7.3 no longer using indexes for LIKE queries |