From: Bill Moran <wmoran@collaborativefusion.com>
To: rafael@akyasociados.com.ar
Cc: pgsql-performance@postgresql.org
Subject: Re: Vacum Analyze problem
Date: Tue, 4 Sep 2007 13:55:59 -0400
Message-ID: <20070904135559.affb0db0.wmoran@collaborativefusion.com> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, rafael@akyasociados.com.ar
Subject: Re: Vacum Analyze problem
In-Reply-To: <20070904135559.affb0db0.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox