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 50DE14F7.4030205@gmx.net
Whole thread Raw
In response to dynamic SQL - possible performance regression in 9.2  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: dynamic SQL - possible performance regression in 9.2  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On 12/27/12 1:07 AM, Pavel Stehule wrote:
> Hello
> 
> I rechecked performance of dynamic SQL and it is significantly slower
> in 9.2 than 9.1
> 
> -- 9.1
> postgres=# create or replace function test() returns void as $$ begin
> for i in 1..1000000 loop execute 'select 1'; end loop; end $$ language
> plpgsql;

I think this is the same as the case discussed at
<CAD4+=qWnGU0qi+iq=EPh6EGPuUnSCYsGDTgKazizEvrGgjo0Sg@mail.gmail.com>.




pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: proposal: ANSI SQL 2011 syntax for named parameters
Next
From: Heikki Linnakangas
Date:
Subject: Re: dynamic SQL - possible performance regression in 9.2