From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: vacuuming problems continued
Date: Mon, 5 Jun 2006 16:41:51 -0400
Message-ID: <20060605204151.GC7071@phlogiston.dyndns.org> (raw)
In-Reply-To: <92d3a4950606010454y67293765o56001e8996975b45@mail.gmail.com>
References: <92d3a4950606010454y67293765o56001e8996975b45@mail.gmail.com>
On Thu, Jun 01, 2006 at 01:54:08PM +0200, Antoine wrote:
> Hi,
> We just don't seem to be getting much benefit from autovacuum. Running
> a manual vacuum seems to still be doing a LOT, which suggests to me
> that I should either run a cron job and disable autovacuum, or just
> run a cron job on top of autovacuum.
What the others said; but also, which version of autovacuum (== which
version of the database) is this? Because the early versions had a
number of missing bits to them that tended to mean the whole thing
didn't hang together very well.
> I have been thinking about strategies and am still a bit lost. Our
> apps are up 24/7 and we didn't code for the eventuality of having the
> db going offline for maintenance... we live and learn!
You shouldn't need to, with anything after 7.4, if your vacuum
regimen is right. There's something of a black art to it, though.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
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: ajs@crankycanuck.ca
Subject: Re: vacuuming problems continued
In-Reply-To: <20060605204151.GC7071@phlogiston.dyndns.org>
* 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