Re: Prepared statements and suboptimal plans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Royce Ausburn <royce(dot)ml(at)inomial(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Prepared statements and suboptimal plans
Date: 2011-09-21 00:36:35
Message-ID: 9289.1316565395@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig Ringer <ringerc(at)ringerc(dot)id(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Lester 2011-09-21 00:42:41 Re: Prepared statements and suboptimal plans
Previous Message Royce Ausburn 2011-09-21 00:17:41 Re: Prepared statements and suboptimal plans