Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] select like...not using index

From: pgsql(at)mohawksoft(dot)com
To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org,"PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: [HACKERS] select like...not using index
Date: 2004-05-28 23:12:18
Message-ID: 16806.24.91.171.78.1085785938.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
> Sometime between yesterday and today queries in the form of
> "select * from t where t.f like 'k%'" have been broken so that they
> never use the index (on win32, not sure about others).
>
> On win32, at least, they have been broken for a while but this was due
> to a known issue based on the locales.  AFAICT, the current cvs has
> addressed this issue and (show lc_collate returns C) there seems to be
> no reason why the queries aren't working properly.
>
> Merlin

Did you do an ANALYZE on the table?
Are there a lot of duplicate keys?
How big is the table?
What does the "explain" look like?

In response to

pgsql-hackers by date

Next:From: Dann CorbitDate: 2004-05-28 23:14:50
Subject: Re: -Wall and Wmissing-prototype
Previous:From: pgsqlDate: 2004-05-28 23:08:52
Subject: Re: Extended customizing, SQL functions,

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-05-29 03:12:00
Subject: Re: nested transaction patch build?
Previous:From: Merlin MoncureDate: 2004-05-28 20:57:59
Subject: Re: could not locate my own executable path

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group