Date: Tue, 4 Sep 2007 13:55:59 -0400
From: Bill Moran <wmoran@collaborativefusion.com>
To: rafael@akyasociados.com.ar
Cc: pgsql-performance@postgresql.org
Subject: Re: Vacum Analyze problem
Message-Id: <20070904135559.affb0db0.wmoran@collaborativefusion.com>
In-Reply-To: 
 <1275.192.168.1.229.1188926827.squirrel@webmail.akyasociados.com.ar>
References: 
 <1275.192.168.1.229.1188926827.squirrel@webmail.akyasociados.com.ar>
Organization: Collaborative Fusion
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

In response to rafael@akyasociados.com.ar:

> Hello everyone:
> 
>    I wanted to ask you about how the VACUUM ANALYZE works. is it possible
> that something can happen in order to reset its effects forcing to execute
> the VACUUM ANALYZE comand again? i am asking this because i am struggling
> with a query which works ok after i run a VACUUM ANALYZE, however, sudennly,
> it starts to take forever (the execution of the query) until i make another
> VACUUM ANALYZE, and so on ...
>    I'd like to point that i am a novice when it comes to non basic
> postgresql performance related stuff.
> 
> Thank you all in advance

To add to Mikko's comments:

Periodic vacuuming and analyzing is a mandatory part of running a
PostgreSQL database server.  You'll probably be best served to configure
the autovacuum daemon to handle this for you.  See the postgresql.conf
config file.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023