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 E39A69DCE11 for ; Mon, 19 Dec 2005 09:25:30 -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 37912-05 for ; Mon, 19 Dec 2005 09:25:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by postgresql.org (Postfix) with SMTP id A6A619DCE08 for ; Mon, 19 Dec 2005 09:25:26 -0400 (AST) Received: (qmail 5323 invoked from network); 19 Dec 2005 13:25:26 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 19 Dec 2005 13:25:26 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 00F6841A0; Mon, 19 Dec 2005 08:25:24 -0500 (EST) Date: Mon, 19 Dec 2005 08:25:24 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Does VACUUM reorder tables on clustered indices Message-ID: <20051219132524.GA6777@phlogiston.dyndns.org> References: <1134940325.43a5d0a5a882e@webmail.adontendev.net> <20051218220139.GA1651@surnet.cl> <13769.1134961702@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <13769.1134961702@sss.pgh.pa.us> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/156 X-Sequence-Number: 23698 On Sun, Dec 18, 2005 at 10:08:22PM -0500, Tom Lane wrote: > > Just for the record, that behavior is seriously broken: it violates > MVCC if any of the deleted tuples are still visible to anyone else. Does it remove tuples that VACUUM FULL wouldn't? I always thought it did essentially the same thing? A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin