From: Dave Dutcher <dave@tridecap.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, 4 Oct 2006 09:12:07 -0500
Message-ID: <009001c6e7bf$13d58d10$8300a8c0@tridecap.com> (raw)
In-Reply-To: <168519350610040647v395f1aeag8e9c6825ad25320e@mail.gmail.com>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
>
> lc_collate is C, as are all the other lc settings.
>
> I have run the analyze commands.
>
> Still the same.
That is strange. I figured it had to be related to the locale and the LIKE
operator. I'm not an expert on these locale issues, but I'd be curious to
see if it would start using an index if you added an index like this:
CREATE INDEX test_index ON t_order (c_number varchar_pattern_ops);
Dave
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: dave@tridecap.com, sgodden@gmail.com
Subject: Re: simple case using index on windows but not on linux
In-Reply-To: <009001c6e7bf$13d58d10$8300a8c0@tridecap.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