Re: Performance problem in PLPgSQL

From: dlight <avinfo79(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance problem in PLPgSQL
Date: 2013-09-18 11:47:58
Message-ID: 1379504878339-5771405.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

So if I run function 10000 with varible inside the query in one session it's
replan each time.

But if whant to teling postgres do not doing this, what shoud i do?

We have more than 10000 runs in one session with varible inside sql. And
have big performance problem in 9.2 and 9.3.

Here is my tests.
http://postgresql.1045698.n5.nabble.com/function-execute-on-v-9-2-slow-down-tp5767170p5771403.html

We want change pg version but can't doing that because of performance
regression in 9.2 and 9.3.:(

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-problem-in-PLPgSQL-tp5764796p5771405.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-09-18 11:52:29 psql should show disabled internal triggers
Previous Message Dean Rasheed 2013-09-18 11:45:24 Re: psql sets up cancel handler very early