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

Re: select like...not using index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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: select like...not using index
Date: 2004-05-29 04:35:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-hackers-win32
"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> 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).  

Not here ... and I've seen no commits that I'd have thought would affect
that.  Check for local configuration changes.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2004-05-29 05:11:18
Subject: Re: Extended customizing, SQL functions,
Previous:From: Tom LaneDate: 2004-05-29 04:20:07
Subject: Re: temp tables broken in CVS HEAD?

pgsql-hackers-win32 by date

Next:From: Thomas SwanDate: 2004-05-29 05:01:42
Subject: Re: could not locate my own executable path
Previous:From: Bruce MomjianDate: 2004-05-29 03:12:00
Subject: Re: nested transaction patch build?

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