From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Александр Белинский <avinfo79(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Function execute slow down in 9.2 |
Date: | 2013-08-21 09:03:28 |
Message-ID: | CAFj8pRCYBbnaOOd0g9BK3hij_vbQV2x9hQPGSanq42w+4oQ39g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
2013/8/16 Александр Белинский <avinfo79(at)gmail(dot)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.
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matheus de Oliveira | 2013-08-21 13:10:15 | Re: How to investiage slow insert problem |
Previous Message | Rural Hunter | 2013-08-21 01:33:14 | Re: How to investiage slow insert problem |