Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum

From: damien clochard <damien(at)dalibo(dot)info>
To: farrukhusmanrana <farrukhusmanrana(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Autovacuum
Date: 2011-08-31 20:07:46
Message-ID: 4E5E9492.3080801@dalibo.info (view raw or flat)
Thread:
Lists: pgsql-novice
Le 31/08/2011 18:18, farrukhusmanrana a écrit :
> Hello,
> 
> I want to see when autovacuum start in the log.
> Due to some reasons we need to see when autovaccum starts and end.
> 1) Is there any easy way to enable any logging switch and it would go to
> log? I tired it but could not see anything in log(auto vacuum was running
> and completing)

set log_autovacuum_min_duration to zero and your server will log all
autovacuum actions.

http://www.postgresql.org/docs/8.3/static/runtime-config-autovacuum.html

> 2) If option one is not possible then can I write a trigger on
> pg_stat_user_tables? and push something in log in that trigger when
> last_autovacuum changes?

This is a complex and very bad idea :-)


-- 
damien clochard
dalibo.com | dalibo.org

In response to

  • Autovacuum at 2011-08-31 16:18:00 from farrukhusmanrana

pgsql-novice by date

Next:From: Daniel CintraDate: 2011-08-31 20:40:41
Subject: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits
Previous:From: farrukhusmanranaDate: 2011-08-31 16:18:00
Subject: Autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group