| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: dynamic SQL - possible performance regression in 9.2 |
| Date: | 2012-12-28 21:53:59 |
| Message-ID: | 50DE14F7.4030205@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)mail(dot)gmail(dot)com>.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2012-12-28 22:11:28 | Re: dynamic SQL - possible performance regression in 9.2 |
| Previous Message | Gavin Flower | 2012-12-28 21:41:11 | Re: proposal: ANSI SQL 2011 syntax for named parameters |