Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 May 2004 19:12:18 -0400 (EDT)
- Message-id: <16806(dot)24(dot)91(dot)171(dot)78(dot)1085785938(dot)squirrel(at)mail(dot)mohawksoft(dot)com>
> 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?
- References:
- select like...not using index
- From: Merlin Moncure
- select like...not using index
- Prev by Date: Re: could not locate my own executable path
- Next by Date: Re: nested transaction patch build?
- Previous by thread: select like...not using index
- Next by thread: Re: select like...not using index
- Indexes: