Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster

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