| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2004-05-28 23:14:50 | Re: -Wall and Wmissing-prototype |
| Previous Message | pgsql | 2004-05-28 23:08:52 | Re: Extended customizing, SQL functions, |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-05-29 03:12:00 | Re: nested transaction patch build? |
| Previous Message | Merlin Moncure | 2004-05-28 20:57:59 | Re: could not locate my own executable path |