Re: Function execute slow down in 9.2

From: Александр Белинский <avinfo79(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Function execute slow down in 9.2
Date: 2013-08-16 12:27:39
Message-ID: 520E1ABB.1000308@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2013-08-16 19:20:17 Re: queries with DISTINCT / GROUP BY giving different plans
Previous Message Albe Laurenz 2013-08-16 07:26:09 Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral