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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Anoo Sivadasan Pillai <aspillai(at)in(dot)rm(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
Date: 2008-01-09 05:06:44
Message-ID: 20080109050644.GF20913@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anoo Sivadasan Pillai 2008-01-09 06:00:33 Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster
Previous Message Anoo Sivadasan Pillai 2008-01-09 04:03:57 After Vacuum Analyse - Procedure performance not improved - Innner select is faster