Re: Performance problem in PLPgSQL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Performance problem in PLPgSQL
Дата
Msg-id CAFj8pRAup734osQ5r4nNYUJ2V9Rc_V-UFRKV56_RbaUXBJfdVA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance problem in PLPgSQL  (dlight <avinfo79@gmail.com>)
Ответы Re: Performance problem in PLPgSQL  (dlight <avinfo79@gmail.com>)
Список pgsql-hackers


2013/9/18 dlight <avinfo79@gmail.com>
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.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Assertions in PL/PgSQL
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Where to load modules from?