| From: | Robert Haas <robertmhaas(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 on v.9.2 slow down |
| Date: | 2013-09-16 23:40:28 |
| Message-ID: | CA+TgmoYAjrWO2pEcZF9qXwWEA_s-mux8J_X3YsGDgS_NjwEhBQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Aug 12, 2013 at 8:21 AM, Александр Белинский <avinfo79(at)gmail(dot)com> wrote:
> Hi!
> I can't explain why function is slow down on same data.
> Postgresql.conf the same, hardware is more powerful.
> Diffrents is postgresql version
Hmm. PostgreSQL 9.2 will sometimes replan queries a number of times
where older releases, looking to see whether the choice of bind
variables affects the optimal plan choice, where older versions would
create a generic plan on first execution and use it forever. I'm not
sure whether that behavior applies in this situation, though. If you
run it say 15 times does it eventually start running faster?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Дмитрий Дегтярёв | 2013-09-17 11:55:01 | Re: Cpu usage 100% on slave. s_lock problem. |
| Previous Message | Marc Mamin | 2013-09-16 19:22:39 | Re: stable and immutable functions in GROUP BY clauses. |