Le 31/08/2011 18:18, farrukhusmanrana a écrit :
> 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
> 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 :-)
dalibo.com | dalibo.org
In response to
- Autovacuum at 2011-08-31 16:18:00 from farrukhusmanrana
pgsql-novice by date
|Next:||From: Daniel Cintra||Date: 2011-08-31 20:40:41|
|Subject: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits|
|Previous:||From: farrukhusmanrana||Date: 2011-08-31 16:18:00|