Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BC9689FA0A7 for ; Tue, 4 Sep 2007 15:40:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 88465-06 for ; Tue, 4 Sep 2007 15:39:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id 7CF419F9D60 for ; Tue, 4 Sep 2007 15:39:58 -0300 (ADT) Received: from [192.168.0.251] ([71.251.196.74]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JNU00269X68B8O5@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Tue, 04 Sep 2007 13:39:45 -0500 (CDT) Date: Tue, 04 Sep 2007 14:39:44 -0400 From: Jean-David Beyer Subject: About autovacuum To: Pgsql performance Message-id: <46DDA670.3000108@verizon.net> Organization: Institute for Regimented Whimsey MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Enigmail-Version: 0.94.0.0 User-Agent: Thunderbird 1.5.0.9 (X11/20070317) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/24 X-Sequence-Number: 26569 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? -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 14:35:01 up 26 days, 17:57, 2 users, load average: 4.31, 4.40, 4.78