Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6FC4D2E2FED for ; Thu, 20 Dec 2007 02:50:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46404-05 for ; Thu, 20 Dec 2007 02:50:46 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id E5C362E2FCB for ; Thu, 20 Dec 2007 02:50:47 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J5FF1-0003DN-8x for pgsql-admin@postgresql.org; Wed, 19 Dec 2007 22:50:47 -0800 Message-ID: <14431704.post@talk.nabble.com> Date: Wed, 19 Dec 2007 22:50:47 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: about the performance of autovacuum and vacuumdb? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ivan.hou@msa.hinet.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.519 tagged_above=0 required=5 tests=BAYES_05=-1.11, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: * X-Archive-Number: 200712/197 X-Sequence-Number: 27714 i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3) 1. enable autovacuum without using vacuumdb -f mydb in crontab. 2. using crontab to vacuumdb in every 10 min (autovacuum disable) the method 2 got more free space than method 1. the disk size of database still increased in method 1. so, what's the advantage of autovacuum? -- View this message in context: http://www.nabble.com/about-the-performance-of-autovacuum-and-vacuumdb--tp14431704p14431704.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.