2013/8/16 Александр Белинский <avinf...@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<http://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. > > > > > >
