Re: dynamic SQL - possible performance regression in 9.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: dynamic SQL - possible performance regression in 9.2
Date
Msg-id 25644.1357334227@sss.pgh.pa.us
Whole thread Raw
In response to Re: dynamic SQL - possible performance regression in 9.2  (Josh Berkus <josh@agliodbs.com>)
Responses Re: dynamic SQL - possible performance regression in 9.2
Re: dynamic SQL - possible performance regression in 9.2
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> Next question is what people think about back-patching into 9.2 so as
>> to eliminate the performance regression vs 9.1.

> 8% is a pretty serious regression, for those of us with applications
> which do a lot of dynamic SQL.  As a reminder, many people do dynamic
> SQL even in repetitive, performance-sensitive functions in order to
> avoid plan caching.

Well, of course, people with that type of problem should probably
rethink their use of dynamic SQL when they move to 9.2 anyway, because
that's the case where the new plancache code could actually help them
if they'd only let it.

But anyway, nobody seems to be speaking against back-patching, so
I'll go do it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: json api WIP patch
Next
From: Dimitri Fontaine
Date:
Subject: Re: Event Triggers: adding information