Vacuum only writes normal operations messages to the logs if you have
log_min_messages set to DEBUG2 or DEBUG3 (with DEBUG3 giving more
output). I'm not sure what query stats are kept for autovacuum
activities in 8.3, but in versions <= 8.2.x you can run the following
query to see what autovacuum is currently doing:
SELECT current_query
FROM pg_stat_activity
WHERE query_start IS NULL;
This works because autovacuum vacuum queries started by autovacuum
apparently don't have their start time (or client_addr) noted.
On Dec 13, 2007, at 8:00 AM, MG wrote:
Hello,
when I put the autovacuum on, where can I check what it does? Is
there any log-file?
Regards
Michaela
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
