Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2FA3E2E2FA7 for ; Thu, 20 Dec 2007 02:50:26 -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 47031-02 for ; Thu, 20 Dec 2007 02:50:19 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id D08172E2F9D for ; Thu, 20 Dec 2007 02:50:20 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J5FEZ-0003Cm-Kc for pgsql-admin@postgresql.org; Wed, 19 Dec 2007 22:50:19 -0800 Message-ID: <14431695.post@talk.nabble.com> Date: Wed, 19 Dec 2007 22:50:19 -0800 (PST) From: "ivan.hou" To: pgsql-admin@postgresql.org Subject: =?UTF-8?Q?_about_the_performance_?= =?UTF-8?Q?of_autovacuum_and_vacuumdb=3F_=E9=81=B8=E9=A0=85?= 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/196 X-Sequence-Number: 27713 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--%E9%81%B8%E9%A0%85-tp14431695p14431695.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.