Re: simple case using index on windows but not on linux - Mailing list pgsql-performance

simon godden wrote:
> On 10/4/06, Richard Huxton <dev@archonet.com> wrote:
>> simon godden wrote:
>>
>>  From psql, a "show all" command will list all your config settings and
>> let you check the lc_xxx values are correct.
>
> lc_collate is C, as are all the other lc settings.
>
> I have run the analyze commands.
>
> Still the same.

Can you post EXPLAIN ANALYSE for the LIKE and <> queries that should be
using the index? With enable_seqscan on and off please.

--
   Richard Huxton
   Archonet Ltd