| From: | Madison Kelly <linux(at)alteeve(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: B-Tree index not being used |
| Date: | 2005-07-02 15:20:23 |
| Message-ID: | 42C6B0B7.5010006@alteeve.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tom Lane wrote:
> Madison Kelly <linux(at)alteeve(dot)com> writes:
>
>> Can anyone see why the index might not be being used?
>
>
> You didn't initdb in 'C' locale. You can either re-initdb,
> or create a specialized index with a non-default operator class
> to support LIKE. See the documentation.
>
> regards, tom lane
I'll look into the non-default op class. I want to keep anything that
tweaks the DB in my code so that a user doesn't need to modify anything
on their system.
Thanks!
Madison
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Enrico Weigelt | 2005-07-03 22:28:30 | Re: investigating slow queries through pg_stat_activity |
| Previous Message | Tom Lane | 2005-07-02 13:54:40 | Re: B-Tree index not being used |