Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE, leading percent, bind parameters and indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LIKE, leading percent, bind parameters and indexes
Date
Msg-id 23592.1148745160@sss.pgh.pa.us
Whole thread Raw
In response to Re: LIKE, leading percent, bind parameters and indexes  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: LIKE, leading percent, bind parameters and indexes
List pgsql-hackers
Tree view 
Martijn van Oosterhout <kleptog@svana.org> writes:
> How about the suggestion of using a sequential index scan like the
> recent changes to VACUUM in the case that there are no regular index
> quals?

Nonstarter (hint: the solution we found for VACUUM assumes there can
be only one).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: LIKE, leading percent, bind parameters and indexes
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Inefficient bytea escaping?