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

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@myemma.com
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