From: Richard Huxton <dev@archonet.com>
To: simon godden <sgodden@gmail.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: simple case using index on windows but not on linux
Date: Wed, 04 Oct 2006 14:47:33 +0100
Message-ID: <4523BB75.9020200@archonet.com> (raw)
In-Reply-To: <168519350610040635r4d041bd7vba47ca0e31a4c7d0@mail.gmail.com>
References: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@mail.gmail.com>
<45237AD0.50604@enterprisedb.com>
<168519350610040219n648a282hf159ff272e0f672a@mail.gmail.com>
<45238085.3000407@archonet.com>
<168519350610040240k346bd99fj9537822d79443f8c@mail.gmail.com>
<45238F54.70609@archonet.com>
<168519350610040635r4d041bd7vba47ca0e31a4c7d0@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, sgodden@gmail.com
Subject: Re: simple case using index on windows but not on linux
In-Reply-To: <4523BB75.9020200@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox