Re: Auto vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Auto vacuum
Date: 2007-04-17 20:30:45
Message-ID: 12357.1176841845@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Carol Walter <walterc(at)indiana(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jessica Richard 2007-04-18 00:34:18 who can tell me the correct syntax to use dblink to talk to a table in another database
Previous Message Carol Walter 2007-04-17 20:25:14 Re: Auto vacuum