From: Robert Treat <robert@omniti.com>
To: pgsql-admin@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Carol Walter <walterc@indiana.edu>
Subject: Re: Auto vacuum
Date: Tue, 17 Apr 2007 21:57:53 -0400
Message-ID: <200704172157.54249.robert@omniti.com> (raw)
In-Reply-To: <12357.1176841845@sss.pgh.pa.us>
References: <DFF8F759-C7C6-4092-BCB9-C7571E1C07E9@indiana.edu>
<E28DBA41-80C6-40FB-9D4B-141FF3E53A8A@indiana.edu>
<12357.1176841845@sss.pgh.pa.us>
On Tuesday 17 April 2007 16:30, Tom Lane wrote:
> 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.
>
Till then, take a look at pg_stat_all_tables, which contains information on
last autovacuum and autoanalyze runs for each table.
--
Robert Treat
Database Architect
http://www.omniti.com
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: robert@omniti.com, tgl@sss.pgh.pa.us, walterc@indiana.edu
Subject: Re: Auto vacuum
In-Reply-To: <200704172157.54249.robert@omniti.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