From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Ruben Rubio <ruben@rentalia.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Vacuum full is slow
Date: Fri, 23 Mar 2007 11:32:35 -0500
Message-ID: <1174667555.10744.2.camel@state.g2switchworks.com> (raw)
In-Reply-To: <45FE6DD4.7080304@rentalia.com>
References: <45FE6DD4.7080304@rentalia.com>
On Mon, 2007-03-19 at 06:02, Ruben Rubio wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> Vacuum full is very slow for me . I dont know how to speed it up. It
> takes between 60 and 90 minutes.
>
> I have set up autovacuum but I also run vacuum full once per week.
Note two things.
1: you need to update your pgsql version. 8.1.3 is a bit old.
2: You shouldn't normally need to run vacuum full. Vacuum full is
there to get you out of problems created when regular vacuum falls
behind. It contributes to index bloat as well. If routine vacuuming
isn't working, regular vacuum full is not the answer (well, 99% of the
time it's not). Fixing routing vacuuming is the answer.
If you don't have an actual problem with routine vacuuming, you would be
better off writing a monitoring script to keep track of bloat in tables
and send you an email than running vacuum full all the time.
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: smarlowe@g2switchworks.com, ruben@rentalia.com
Subject: Re: Vacuum full is slow
In-Reply-To: <1174667555.10744.2.camel@state.g2switchworks.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