Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: 8.1.3 - autovacuum question
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Chris Hoover <revoohc(at)gmail(dot)com>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: 8.1.3 - autovacuum question
- Date: Mon, 26 Jun 2006 16:59:30 -0400
Chris Hoover wrote: > 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? Yeah, autovacuum is pretty stupid in its logging. You can put log_min_messages (or min_log_messages, I always forget which one it is) DEBUG2 to get more detailed messages. You'll get a lot other stuff as well :-( -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- References:
- 8.1.3 - autovacuum question
- From: Chris Hoover
- 8.1.3 - autovacuum question
- Prev by Date: RES: Hiding table structure information
- Next by Date: Re: 8.1.3 - autovacuum question
- Previous by thread: 8.1.3 - autovacuum question
- Next by thread: Re: 8.1.3 - autovacuum question
- Indexes: