Thread: Autovacuum

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)
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?
- Farrukh Usman

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Autovacuum-tp4754835p4754835.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

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