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

From: Richard Huxton <dev(at)archonet(dot)com>
To: simon godden <sgodden(at)gmail(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: simple case using index on windows but not on linux
Date: 2006-10-04 14:07:03
Message-ID: 4523C007.4050606@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-10-04 14:12:07 Re: simple case using index on windows but not on linux
Previous Message Brad Nicholson 2006-10-04 13:52:26 Re: PostgreSQL Caching