Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A48069FA01B for ; Tue, 4 Sep 2007 16:01:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76638-03 for ; Tue, 4 Sep 2007 16:00:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id 597519F9BD0 for ; Tue, 4 Sep 2007 16:01:04 -0300 (ADT) Received: from vanquish.pitbpa0.priv.collaborativefusion.com (vanquish.pitbpa0.priv.collaborativefusion.com [192.168.2.61]) (SSL: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Tue, 04 Sep 2007 15:01:03 -0400 id 00056415.46DDAB6F.00008DC1 Date: Tue, 4 Sep 2007 15:01:02 -0400 From: Bill Moran To: Jean-David Beyer Cc: Pgsql performance Subject: Re: About autovacuum Message-Id: <20070904150102.6441483b.wmoran@collaborativefusion.com> In-Reply-To: <46DDA670.3000108@verizon.net> References: <46DDA670.3000108@verizon.net> Organization: Collaborative Fusion X-Mailer: Sylpheed 2.4.4 (GTK+ 2.10.14; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/28 X-Sequence-Number: 26573 In response to Jean-David Beyer : > I have this turned on, and if I look at the log, it runs once a minute, > which is fine. > > But what does it do? I.e, it runs VACUUM, but does it also do an analyze? Yes. If you turn up the debugging level, you'll see detailed log messages about its activities. There were discussions on other lists about improving autovacuum's log messages, I'm pretty sure it will log more helpful information in 8.3. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@collaborativefusion.com Phone: 412-422-3463x4023