From: Александр Белинский <avinfo79@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Function execute slow down in 9.2
Date: Fri, 16 Aug 2013 15:27:39 +0300
Message-ID: <520E1ABB.1000308@gmail.com> (raw)
In-Reply-To: <CAFj8pRD60swnoKUZ6OzbcgxQezZ6qwKZ9cxO9Gh=XQFz3Zdxtg@mail.gmail.com>
References: <5208F85F.50706@gmail.com>
<CAFj8pRD60swnoKUZ6OzbcgxQezZ6qwKZ9cxO9Gh=XQFz3Zdxtg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: avinfo79@gmail.com, pavel.stehule@gmail.com
Subject: Re: Function execute slow down in 9.2
In-Reply-To: <520E1ABB.1000308@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox