Re: Prepared statements and suboptimal plans - Mailing list pgsql-performance

From Tom Lane
Subject Re: Prepared statements and suboptimal plans
Date
Msg-id 9289.1316565395@sss.pgh.pa.us
Whole thread Raw
In response to Re: Prepared statements and suboptimal plans  (Craig Ringer <ringerc@ringerc.id.au>)
Responses Re: Prepared statements and suboptimal plans  (Andy Lester <andy@petdance.com>)
List pgsql-performance
Craig Ringer <ringerc@ringerc.id.au> writes:
> On 21/09/2011 7:27 AM, Royce Ausburn wrote:
>> We've been worst hit by this query on an 8.3 site.  Another site is
>> running 8.4.  Have there been improvements in this area recently?
>> Upgrading to 9.0 might be viable for us.

> Tom just mentioned that 9.1 will be able to re-plan parameterized
> prepared statements, so this issue will go away.

9.2, sorry, not 9.1.  We could use some motivated people testing that
aspect of GIT HEAD, though, since I doubt the policy for when to re-plan
is quite ideal yet.

            regards, tom lane

pgsql-performance by date:

Previous
From: Royce Ausburn
Date:
Subject: Re: Prepared statements and suboptimal plans
Next
From: Andy Lester
Date:
Subject: Re: Prepared statements and suboptimal plans