Re: Performance problem in PLPgSQL - Mailing list pgsql-hackers

From dlight
Subject Re: Performance problem in PLPgSQL
Date
Msg-id 1379504878339-5771405.post@n5.nabble.com
Whole thread Raw
In response to Re: Performance problem in PLPgSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Performance problem in PLPgSQL
Re: Performance problem in PLPgSQL
List 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.



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: psql sets up cancel handler very early
Next
From: Andres Freund
Date:
Subject: psql should show disabled internal triggers