Re: [PERFORM] Poor plan choice in prepared statement

2008-12-31 Thread Alvaro Herrera
Tom Lane escribió: > Scott Carey writes: > > I have also had a case where one query would take a couple hundred > > ms to parse, but was fairly fast to plan and execute (1/3 the parse > > cost) -- yet another case where a prepared statement that re-plans > > each execution would be helpful. At l

Re: [PERFORM] Poor plan choice in prepared statement

2008-12-31 Thread bricklen
Hi Guillaume, On Wed, Dec 31, 2008 at 1:12 AM, Guillaume Smet wrote: > On Tue, Dec 30, 2008 at 7:59 PM, bricklen wrote: >> I would like to continue to use bind variables to prevent sql >> injection, but I'd like to force a plan re-parse for every single >> query (if necessary?) > > As far as I u

Re: [PERFORM] Poor plan choice in prepared statement

2008-12-31 Thread Guillaume Smet
On Tue, Dec 30, 2008 at 7:59 PM, bricklen wrote: > I would like to continue to use bind variables to prevent sql > injection, but I'd like to force a plan re-parse for every single > query (if necessary?) As far as I understand your problem, you don't care about using prepared statements. If so,