From: Matthew T. O'Connor <matthew@zeut.net>
To: arnaulist@andromeiberica.com
Cc: pgsql-admin@postgresql.org
Subject: Re: When vaccuum full should be performed with postgresql-8.1
Date: Tue, 19 Sep 2006 00:08:14 -0400
Message-ID: <450F6D2E.3030908@zeut.net> (raw)
In-Reply-To: <450E726A.6040508@andromeiberica.com>
References: <450E726A.6040508@andromeiberica.com>
Arnau wrote:
> I'm migrating our DDBB from postgresql 7.4 to postgresql 8.1. In
> postgreql 7.4 we don't have autovaccum running. So, every night before
> doing the daily backup we do a "vaccuumdb -f -z" for each DB. My doubt
> is, the autovaccuum with the version 8.1 is started by default and I
> don't know how often I should perform the "vaccuumdb -f -z" or now
> it's not necessary to do it at all.
First off, you should never really need vacuumdb -f, in fact autovacuum
doesn't do full vacuums, rather it only does the standard vacuum.
In theory autovacuum should perform all the vacuuming that is needed,
however, in practice this isn't always the case. First the most people
find the default thresholds for autovacuum in 8.1 are too conservative
and second it can be a bit hard to monitor what autovacuum is doing.
Both of these issues are improved in 8.2. In summary, try it and see.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: matthew@zeut.net, arnaulist@andromeiberica.com
Subject: Re: When vaccuum full should be performed with postgresql-8.1
In-Reply-To: <450F6D2E.3030908@zeut.net>
References: <450E726A.6040508@andromeiberica.com> <450F6D2E.3030908@zeut.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