Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
Date
Msg-id 20080109050644.GF20913@alvh.no-ip.org
Whole thread Raw
In response to After Vacuum Analyse - Procedure performance not improved - Innner select is faster  ("Anoo Sivadasan Pillai" <aspillai@in.rm.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Anoo Sivadasan Pillai"
Date:
Subject: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
Next
From: "Anoo Sivadasan Pillai"
Date:
Subject: Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster