> 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.
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 Corbit||Date: 2004-05-28 23:14:50|
|Subject: Re: -Wall and Wmissing-prototype|
|Previous:||From: pgsql||Date: 2004-05-28 23:08:52|
|Subject: Re: Extended customizing, SQL functions,|
pgsql-hackers-win32 by date
|Next:||From: Bruce Momjian||Date: 2004-05-29 03:12:00|
|Subject: Re: nested transaction patch build?|
|Previous:||From: Merlin Moncure||Date: 2004-05-28 20:57:59|
|Subject: Re: could not locate my own executable path|