> Of course, I could modify the application and send different SQL
> depending on which case we're in or just constructing a query with a
> literal each time, but is there a way to add a hint to the SQL that
> would cause the query to be re-planned if it's a case that could use the
> index? Or can I convince the (Perl) driver to do so?
There should be an option to tell DBD::Pg not to cache a query plan.
Let's see ....
yes. pg_server_prepare=0, passed to the prepare() call.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Tobias Brox||Date: 2005-06-23 01:06:04|
|Subject: Re: Performance Tuning Article|
|Previous:||From: Kurt De Grave||Date: 2005-06-22 19:25:20|
|Subject: parameterized LIKE does not use index|