From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-performance@postgresql.org
Subject: VACUUM vs auto-vacuum daemon
Date: Tue, 12 Jun 2007 18:54:12 +0300
Message-ID: <f4mfin$1vjf$1@news.hub.org> (raw)
Hi there,
Using explicitly VACUUM command give me the opportunity to fine tune my
VACUUM scheduling parameters, after I analyze the log generated by VACUUM
VERBOSE.
On the other hand I'd like to use the auto-vacuum mechanism because of its
facilities. Unfortunately, after I made some initial estimations for
autovacuum_naptime, and I set the specific data into pg_autovacuum table, I
have not a feedback from the auto-vacuum mechanism to check that it works
well or not. It would be nice to have some kind of log similar with the one
generated by VACUUM VERBOSE. Is the auto-vacuum mechanism able to provide
such a useful log ?
TIA,
Sabin
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: sabin.coanda@deuromedia.ro
Subject: Re: VACUUM vs auto-vacuum daemon
In-Reply-To: <f4mfin$1vjf$1@news.hub.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