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

From Peter Eisentraut
Subject Re: dynamic SQL - possible performance regression in 9.2
Date
Msg-id 50E599CA.7040603@gmx.net
Whole thread Raw
In response to Re: dynamic SQL - possible performance regression in 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dynamic SQL - possible performance regression in 9.2
List pgsql-hackers
On 1/1/13 6:48 PM, Tom Lane wrote:
> I wrote:
>> > I'm inclined to think that Heikki's patch doesn't go far enough, if we
>> > want to optimize behavior in this case.  What we really want to happen
>> > is that parsing, planning, and execution all happen in the caller's
>> > memory context, with no copying of parse or plan trees at all - and we
>> > could do without overhead such as dependency extraction and invalidation
>> > checking, too.  This would make SPI_execute a lot more comparable to the
>> > behavior of exec_simple_query().
> Here's a draft patch for that.

This didn't make a difference in my test case.  I might have to do some
bisecting to find where the problem was introduced.



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Proposal: Store "timestamptz" of database creation on "pg_database"