Re: B-Tree index not being used - Mailing list pgsql-performance

From Madison Kelly
Subject Re: B-Tree index not being used
Date
Msg-id 42C6B0B7.5010006@alteeve.com
Whole thread Raw
In response to Re: B-Tree index not being used  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> Madison Kelly <linux@alteeve.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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: B-Tree index not being used
Next
From: Enrico Weigelt
Date:
Subject: Re: investigating slow queries through pg_stat_activity