From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Auto vacuum
Date: Tue, 17 Apr 2007 16:30:45 -0400
Message-ID: <12357.1176841845@sss.pgh.pa.us> (raw)
In-Reply-To: <E28DBA41-80C6-40FB-9D4B-141FF3E53A8A@indiana.edu>
References: <DFF8F759-C7C6-4092-BCB9-C7571E1C07E9@indiana.edu>
<8229.1176840883@sss.pgh.pa.us>
<E28DBA41-80C6-40FB-9D4B-141FF3E53A8A@indiana.edu>
Carol Walter <walterc@indiana.edu> writes:
> 8.2.3 is what is reported when I run psql with the -V option.
In 8.2 you need to increase log_min_messages to see anything about
autovacuum. It reports per-database activity at DEBUG1 and per-table
activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log
with a lot of other chatter as well :-(. There's work going on
right now to improve the reporting of autovac activity for 8.3.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, walterc@indiana.edu
Subject: Re: Auto vacuum
In-Reply-To: <12357.1176841845@sss.pgh.pa.us>
* 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