Date: Thu, 19 Apr 2007 17:07:21 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Carol Walter <walterc@indiana.edu>
Cc: Robert Treat <robert@omniti.com>, pgsql-admin@postgresql.org,
	Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Auto vacuum
Message-ID: <20070419210721.GL13817@alvh.no-ip.org>
Mail-Followup-To: Carol Walter <walterc@indiana.edu>,
	Robert Treat <robert@omniti.com>, pgsql-admin@postgresql.org,
	Tom Lane <tgl@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>
	<200704172157.54249.robert@omniti.com>
	<12A54BAC-0218-40F8-9A8A-26C6268D1617@indiana.edu>
	<20070419145320.GD8402@alvh.no-ip.org>
	<5FB3A3D2-1B25-4DEC-AC42-FB8B5B978E56@indiana.edu>
	<A01C4327-A569-49D0-ACFD-5F71024AE988@indiana.edu>
	<20070419195555.GG13817@alvh.no-ip.org>
	<4BFB0570-723D-4940-B787-ECC59B280A94@indiana.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4BFB0570-723D-4940-B787-ECC59B280A94@indiana.edu>
User-Agent: Mutt/1.5.13 (2006-08-11)

Carol Walter wrote:
> Are you talking about the log that is configured in postgresql.conf?   
> it goes to stderr and is redirected to pg_log directory with a time  
> and date stamp in the filename.  It doesn't seem to logging anything  
> but planner statistics.

Yes, that one.  If it's not logging anything but planner statistics,
then maybe those are the only things configured to be logged, which
would be weird but I think it's possible.  Change log_min_messages to
debug2 and try again.  A lot more messages should show up, including
some about autovacuum.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.