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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
