From: Alvaro Herrera <alvherre@commandprompt.com>
To: Anoo Sivadasan Pillai <aspillai@in.rm.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
Date: Wed, 9 Jan 2008 02:06:44 -0300
Message-ID: <20080109050644.GF20913@alvh.no-ip.org> (raw)
In-Reply-To: <772CDA49C515244FA14E34443F62E56403AFC90C@EX-INDIA1.internal.rmplc.net>
References: <772CDA49C515244FA14E34443F62E56403AFC90C@EX-INDIA1.internal.rmplc.net>
Anoo Sivadasan Pillai wrote:
> Why the procedure is not getting the performance advantage of Vacuum
> analyse?
Plan caching by the function, probably. Try disconnecting the session
and reconnecting to prove the hypothesis.
If it is a recurring problem for you, you could put the SELECT under
EXECUTE in the function. But most likely this is just a one-time
problem.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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: alvherre@commandprompt.com, aspillai@in.rm.com
Subject: Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
In-Reply-To: <20080109050644.GF20913@alvh.no-ip.org>
* 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