Re: Function execute slow down in 9.2 - Mailing list pgsql-performance

From Александр Белинский
Subject Re: Function execute slow down in 9.2
Date
Msg-id 520E1ABB.1000308@gmail.com
Whole thread Raw
In response to Re: Function execute slow down in 9.2  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Function execute slow down in 9.2
List pgsql-performance
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?

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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral
Next
From: Tomas Vondra
Date:
Subject: Re: queries with DISTINCT / GROUP BY giving different plans