X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64E6FD9330 for ; Tue, 20 Sep 2005 15:53:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28345-05 for ; Tue, 20 Sep 2005 18:53:22 +0000 (GMT) Received: from smtp107.mail.sc5.yahoo.com (smtp107.mail.sc5.yahoo.com [66.163.169.227]) by svr1.postgresql.org (Postfix) with SMTP id 12786D920A for ; Tue, 20 Sep 2005 15:53:21 -0300 (ADT) Received: (qmail 28818 invoked from network); 20 Sep 2005 18:53:21 -0000 Received: from unknown (HELO host-140.engineering.n-able.com) (wander9@209.217.70.195 with plain) by smtp107.mail.sc5.yahoo.com with SMTP; 20 Sep 2005 18:53:21 -0000 Subject: VACUUM FULL vs CLUSTER From: Markus Benne To: pgsql-performance@postgresql.org In-Reply-To: <5.2.0.9.1.20050920144041.0287c300@pop.puc.cl> References: <5.2.0.9.1.20050920144041.0287c300@pop.puc.cl> Content-Type: text/plain Date: Tue, 20 Sep 2005 14:53:19 -0400 Message-Id: <1127242399.26562.15.camel@host-140.engineering.n-able.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3-1.2.101mdk Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/272 X-Sequence-Number: 14580 I have a table that is purged by 25% each night. I'd like to do a vacuum nightly after the purge to reclaim the space, but I think I'll still need to do a vacuum full weekly. Would there be any benefit to doing a cluster instead of the vacuum?