From: Bill Moran <wmoran@collaborativefusion.com>
To: Jean-David Beyer <jeandavid8@verizon.net>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: About autovacuum
Date: Tue, 4 Sep 2007 15:01:02 -0400
Message-ID: <20070904150102.6441483b.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <46DDA670.3000108@verizon.net>
References: <46DDA670.3000108@verizon.net>
In response to Jean-David Beyer <jeandavid8@verizon.net>:
> I have this turned on, and if I look at the log, it runs once a minute,
> which is fine.
>
> But what does it do? I.e, it runs VACUUM, but does it also do an analyze?
Yes. If you turn up the debugging level, you'll see detailed log
messages about its activities.
There were discussions on other lists about improving autovacuum's log
messages, I'm pretty sure it will log more helpful information in 8.3.
--
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, jeandavid8@verizon.net
Subject: Re: About autovacuum
In-Reply-To: <20070904150102.6441483b.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