Re: Vacum Analyze problem

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