Re: simple case using index on windows but not on linux

[Richard Huxton <dev(at)archonet(dot)com>]

simon godden wrote:
> On 10/4/06, Richard Huxton <dev(at)archonet(dot)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