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 702E99DCB34 for ; Thu, 22 Dec 2005 14:59:44 -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 35662-03 for ; Thu, 22 Dec 2005 14:59:43 -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 8BCB59DCACD for ; Thu, 22 Dec 2005 14:59:41 -0400 (AST) Received: (qmail 77494 invoked from network); 22 Dec 2005 18:59:40 -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; 22 Dec 2005 18:59:40 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 99EB341A0; Thu, 22 Dec 2005 13:59:38 -0500 (EST) Date: Thu, 22 Dec 2005 13:59:38 -0500 From: Andrew Sullivan To: Chris Browne Cc: pgsql-sql@postgresql.org Subject: Re: Does VACUUM reorder tables on clustered indices Message-ID: <20051222185938.GA16523@phlogiston.dyndns.org> References: <1134940325.43a5d0a5a882e@webmail.adontendev.net> <20051218220139.GA1651@surnet.cl> <20051220214124.GR28771@pervasive.com> <00e001c605bd$e23ca1a0$0600000a@d505> <20051221003339.GB72143@pervasive.com> <60d5jqja42.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <60d5jqja42.fsf@dba2.int.libertyrms.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.053 required=5 tests=[AWL=0.053] X-Spam-Score: 0.053 X-Spam-Level: X-Archive-Number: 200512/202 X-Sequence-Number: 23744 On Wed, Dec 21, 2005 at 06:36:45PM -0500, Chris Browne wrote: > If I'm considering clustering the Slony-I "sl_log_1" table, forcing it > into memory *is* something I'll consider doing in order to minimize > the time that would-be writers are blocked from writing... Given what Tom Lane recently reported (and assuming I understood his remarks), I think it's a Mighty Bad Idea to CLUSTER sl_log_1. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland