pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Carol Walter <walterc@indiana.edu>
Cc: Robert Treat <robert@omniti.com>
Cc: pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Auto vacuum
Date: Thu, 19 Apr 2007 17:07:21 -0400
Message-ID: <20070419210721.GL13817@alvh.no-ip.org> (raw)
In-Reply-To: <4BFB0570-723D-4940-B787-ECC59B280A94@indiana.edu>
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>

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.

view thread (25+ messages)  latest in thread

Message-ID: <20070419210721.GL13817@alvh.no-ip.org>
Permalink:  ../20070419210721.GL13817@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070419210721.GL13817@alvh.no-ip.org

copy link · copy postgr.es

reply

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: alvherre@commandprompt.com, walterc@indiana.edu, robert@omniti.com, tgl@sss.pgh.pa.us
  Subject: Re: Auto vacuum
  In-Reply-To: <20070419210721.GL13817@alvh.no-ip.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