Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
8.1.3 - autovacuum question
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: 8.1.3 - autovacuum question
- Date: Mon, 26 Jun 2006 16:38:23 -0400
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
- Follow-Ups:
- Re: 8.1.3 - autovacuum question
- From: Tom Lane
- Re: 8.1.3 - autovacuum question
- From: Alvaro Herrera
- Re: 8.1.3 - autovacuum question
- Prev by Date: RES: Hiding table structure information
- Next by Date: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server
- Previous by thread: Hiding table structure information
- Next by thread: Re: 8.1.3 - autovacuum question
- Indexes: