On 10/28/2012 10:06 AM, Tom Lane wrote:
9.2 will only pick the "right" plan if that plan's estimated cost is a good bit cheaper than the "wrong" parameterized plan.
Is it also possible that the planner differences between extended and simple query mode caused this? That really bit us in the ass until EnterpriseDB sent us a patch. From browsing the threads, didn't someone say a similar problem existed in PG core?
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
