In response to rafael@xxxxxxxxxxxxxxxxxxx: > 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@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
