Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to get the optimizer to use indexes - Mailing list pgsql-performance

From Tom Lane
Subject Re: is it possible to get the optimizer to use indexes
Date
Msg-id 6121.1071805440@sss.pgh.pa.us
Whole thread Raw
In response to Re: is it possible to get the optimizer to use indexes  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: is it possible to get the optimizer to use indexes
List pgsql-performance
Tree view 
Dave Cramer <pg@fastcrypt.com> writes:
> after vacuum verbose analyze, I still get [a seqscan]

The other gating factor is that you have to have initdb'd in C locale.
Non-C locales tend to use wild and wooly sort orders that are not
compatible with what LIKE needs.

            regards, tom lane

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: is it possible to get the optimizer to use indexes
Next
From: Dave Cramer
Date:
Subject: Re: is it possible to get the optimizer to use indexes