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

From Richard Huxton
Subject Re: simple case using index on windows but not on linux
Date
Msg-id 4523BB75.9020200@archonet.com
Whole thread Raw
In response to simple case using index on windows but not on linux  ("simon godden" <sgodden@gmail.com>)
Responses Re: simple case using index on windows but not on linux
List pgsql-performance
simon godden wrote:
> I did that, e.g. initdb --locale=C, re-created all my data and have
> exactly the same problem.
>
> I have two indexes, one with no options, and one with the varchar
> operator options.
>
> So the situation now is:
> If I do a like query it uses the index with the varchar options;
> If I do a = query, it uses the index with no options;
> If I do a < or > or any other operator, it reverts back to a seq-scan!
>
> I am on FC5 - any further ideas?  Did I need to do anything specific
> about collating sequence?  I thought that the --locale=C would set
> that for all options.

 From psql, a "show all" command will list all your config settings and
let you check the lc_xxx values are correct.

Make sure you've analysed the database after restoring, otherwise it
will have bad stats available.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: PostgreSQL Caching
Next
From: Brad Nicholson
Date:
Subject: Re: PostgreSQL Caching