Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: Emil Briggs
Date:
Subject: Re: Planner constants for RAM resident databases
Next
From: Madison Kelly
Date:
Subject: Re: B-Tree index not being used