X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3BB5F9FA6B3 for ; Mon, 26 Jun 2006 17:59:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 13141-06 for ; Mon, 26 Jun 2006 17:59:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id 0D59D9FA7B6 for ; Mon, 26 Jun 2006 17:59:33 -0300 (ADT) Received: from 201-221-201-100.bk11-dsl.surnet.cl (HELO alvh.no-ip.org) ([201.221.201.100]) by mx2.surnet.cl with ESMTP; 26 Jun 2006 16:59:31 -0400 X-IronPort-AV: i="4.06,177,1149480000"; d="scan'208"; a="61845992:sNHT19557528" Received: by alvh.no-ip.org (Postfix, from userid 1000) id 6A1A9C2D407; Mon, 26 Jun 2006 16:59:30 -0400 (CLT) Date: Mon, 26 Jun 2006 16:59:30 -0400 From: Alvaro Herrera To: Chris Hoover Cc: "pgsql-admin@postgresql.org" Subject: Re: 8.1.3 - autovacuum question Message-ID: <20060626205930.GC11926@surnet.cl> Mail-Followup-To: Chris Hoover , "pgsql-admin@postgresql.org" References: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/242 X-Sequence-Number: 22204 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