2013/8/16 Александр Белинский <avinfo79@xxxxxxxxx>
12.08.2013 18:24, Pavel Stehule пишет:Thanks for the link ) I read about issue, but I can't understand what should I do?
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
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
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.