Re: Prepared statements and suboptimal plans

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Craig Ringer <ringerc@xxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux