pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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 15:07:03 +0100
Message-ID: <4523C007.4050606@archonet.com> (raw)
In-Reply-To: <168519350610040647v395f1aeag8e9c6825ad25320e@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>
	<4523BB75.9020200@archonet.com>
	<168519350610040647v395f1aeag8e9c6825ad25320e@mail.gmail.com>

simon godden wrote:
> On 10/4/06, Richard Huxton <dev@archonet.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



view thread (12+ messages)  latest in thread

Message-ID: <4523C007.4050606@archonet.com>
Permalink:  ../4523C007.4050606@archonet.com/
Also on:    postgresql.org/message-id/4523C007.4050606@archonet.com

 · 

reply
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: <4523C007.4050606@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