From: Gábor Farkas <gabor@nekomancer.net>
To: pgsql-performance@postgresql.org
Subject: autovacuum: recommended?
Date: Fri, 16 Nov 2007 10:40:43 +0100
Message-ID: <473D659B.1070008@nekomancer.net> (raw)
hi,
we are moving one database from postgresql-7.4 to postgresql-8.2.4.
we have some cronjobs set up that vacuum the database (some tables more
often, some tables less often). now, in pg82, there is the possibility
of using the autovacuum.
my question is: is it recommended to use it? or in other words, should i
only use autovacuum? or it's better to use manual-vacuuming? which one
is the "way of the future" :) ? or should i use both auto-vacuum and
manual-vacuum?
in other words, i'd like to find out, if we should simply stay with the
vacuuming-cronjobs, or should we move to using auto-vacuum? and if we
should move, should we try to set it up the way that no manual-vacuuming
is used anymore?
thanks,
gabor
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: gabor@nekomancer.net
Subject: Re: autovacuum: recommended?
In-Reply-To: <473D659B.1070008@nekomancer.net>
* 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