On Jan 9, 2008, at 12:00 AM, 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.
Is there any way to clear the cached plan manually other than
disconnecting (With the help of some commands/Configuration
settings) ?
Only as of 8.3.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
