Hi,
I am a bit stuck finding out how to log autovacuum activity in PostgreSQL
8=
..2. In the olden times I used to pipe the pg_autovacuum daemon's output
to =
a file. Now pg_autovacuum has become part of the core, I wonder if there's
=
some other possibility of monitoring its activity?
I've got the following logging-settings set:
client_min_messages =3D error
log_min_messages =3D notice
log_error_verbosity =3D default
log_min_error_statement =3D notice
log_min_duration_statement =3D -1
log_line_prefix =3D '<%t - %p: %r@[EMAIL PROTECTED]
>'
Everything else is commented out, i.e. set to defaults. There is however
no=
thing to be found in the logs concerning autovacuum or any standard vacuum
=
at all. I couldn't find anything in the docs regarding the specific
logging=
of vacuum runs. For my nightly vacuum maintenance job, I simply pipe
sterr=
of vacuum verbose analyze to a separate logfile. Concerning autovacuum,
I'=
d like to have some info on when it runs and which tables it has
processed.=
It is running for sure, I can often see the autovacuum process pop up in
t=
op. I only see no means of finding out what it actually does when it's
runn=
ing.
Kind regards
Markus
Computec Media AG
Sitz der Gesellschaft und Registergericht: F=FCrth (HRB 8818)
Vorstandsmitglieder: Johannes S. G=F6zalan (Vorsitzender) und Rainer
Rosenb=
usch
Vorsitzender des Aufsichtsrates: J=FCrg Marquard=20
Umsatzsteuer-Identifikationsnummer: DE 812 575 276
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
