X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 383019DC814 for ; Sun, 18 Dec 2005 18:01:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14412-03 for ; Sun, 18 Dec 2005 18:01:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from alvh.no-ip.org (201-220-123-7.bk10-dsl.surnet.cl [201.220.123.7]) by postgresql.org (Postfix) with ESMTP id B26CB9DC800 for ; Sun, 18 Dec 2005 18:01:18 -0400 (AST) Received: by alvh.no-ip.org (Postfix, from userid 1000) id B3277C348E7; Sun, 18 Dec 2005 19:01:39 -0300 (CLST) Date: Sun, 18 Dec 2005 19:01:39 -0300 From: Alvaro Herrera To: Martin Marques Cc: frank church , pgsql-sql@postgresql.org Subject: Re: Does VACUUM reorder tables on clustered indices Message-ID: <20051218220139.GA1651@surnet.cl> Mail-Followup-To: Martin Marques , frank church , pgsql-sql@postgresql.org References: <1134940325.43a5d0a5a882e@webmail.adontendev.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.132 required=5 tests=[AWL=-1.901, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, RCVD_IN_XBL=3.114] X-Spam-Score: 3.132 X-Spam-Level: *** X-Archive-Number: 200512/150 X-Sequence-Number: 23692 Martin Marques escribió: > On Sun, 18 Dec 2005, frank church wrote: > > > > >Does VACUUMing reorder tables on clustered indices or is it only the > >CLUSTER > >command that can do that? > > Cluster does that. Vacuum only cleans dead tuples from the tables. Note that while reordering, CLUSTER also gets rid of dead tuples, so if you cluster you don't need to vacuum. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.