I turned on autovacuum on one of my database servers over the weekend. I have been looking at the logs trying to see what it is doing. However, all I see are lines like this:
,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing database "postgres"
Is there a way to tell if autovacuum is actually doing any work? As far as I can see, it is running, but has not done any work. Thanks for any help on tracking what autovacuum is doing.
Chris
- [ADMIN] 8.1.3 - autovacuum question Chris Hoover
- Re: [ADMIN] 8.1.3 - autovacuum question Alvaro Herrera
- Re: [ADMIN] 8.1.3 - autovacuum question Tom Lane
- Re: [ADMIN] 8.1.3 - autovacuum question Chris Hoover
- Re: [ADMIN] 8.1.3 - autovacuum question Jim C. Nasby
- Re: [ADMIN] 8.1.3 - autovacuum question Chris Hoover
- Re: [ADMIN] 8.1.3 - autovacuum questi... Bruce Momjian
- Re: [ADMIN] 8.1.3 - autovacuum qu... Jim C. Nasby