Re: Function execute slow down in 9.2

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Function execute slow down in 9.2
Дата
Msg-id CAFj8pRCYBbnaOOd0g9BK3hij_vbQV2x9hQPGSanq42w+4oQ39g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Function execute slow down in 9.2  (Александр Белинский<avinfo79@gmail.com>)
Список pgsql-performance



2013/8/16 Александр Белинский <avinfo79@gmail.com>
12.08.2013 18:24, Pavel Stehule пишет:

Hello

it looks like known issue of sometimes dysfunctional plan cache in
plpgsql in 9.2.

similar issuehttp://postgresql.1045698.n5.nabble.com/Performance-problem-in-PLPgSQL-td5764796.html
Thanks for the link ) I read about issue, but I can't understand what should I do?


You can do nothing. You can check, so described issue is same as your issue, and that is all :(.

It is bug in plan cache implementation.

Regards

Pavel
 
i chage values of seq_page_cost
=1.0
=10.0
= 100.0
= 0.1
=0.01

 but nothing chage, time of function execution the same.






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

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Re: How to investiage slow insert problem
Следующее
От: Matheus de Oliveira
Дата:
Сообщение: Re: How to investiage slow insert problem