Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D50389FB2C3 for ; Thu, 18 Jan 2007 09:31:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 41730-01 for ; Thu, 18 Jan 2007 09:31:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from proton.planetargon.com (proton.planetargon.com [198.145.37.35]) by postgresql.org (Postfix) with ESMTP id 1BFFE9FA2D3 for ; Thu, 18 Jan 2007 09:31:14 -0400 (AST) Received: from [172.16.1.106] (unknown [61.197.227.146]) by proton.planetargon.com (Postfix) with ESMTP id 264FF827FDE; Thu, 18 Jan 2007 05:31:11 -0800 (PST) In-Reply-To: <7e4ba9550701180524h5ebe3390v73292cb91aed89fa@mail.gmail.com> References: <7e4ba9550701180524h5ebe3390v73292cb91aed89fa@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Vacuum v/s Autovacuum Date: Thu, 18 Jan 2007 22:31:10 +0900 To: "Gauri Kanekar" X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/306 X-Sequence-Number: 22907 On Jan 18, 2007, at 22:24 , Gauri Kanekar wrote: > is autovacuum similar to vacuum full analyse verbose. http://www.postgresql.org/docs/8.2/interactive/routine- vacuuming.html#AUTOVACUUM Apparently, no FULL, no VERBOSE (which is only really useful if you want to see the results, not for routine maintenance). Michael Glaesemann grzm seespotcode net