Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id CD1A286A54A for ; Wed, 18 Jan 2012 16:17:28 -0400 (AST) Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rnbwj-0008PJ-Oy for pgsql-admin@postgresql.org; Wed, 18 Jan 2012 20:17:28 +0000 Received: from mail1.sea5.speakeasy.net (mail1.sea5.speakeasy.net [69.17.117.39]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 46272A71D8D for ; Wed, 18 Jan 2012 15:17:09 -0500 (EST) Received: (qmail 5779 invoked from network); 18 Jan 2012 20:17:09 -0000 Received: by simscan 1.4.0 ppid: 16089, pid: 21961, t: 1.2386s scanners: clamav: m: Received: from unknown (HELO [192.168.2.16]) (sribe@elevated-dev.com@[63.227.17.6]) (envelope-sender ) by mail1.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 18 Jan 2012 20:17:08 -0000 Subject: Re: CLUSTER command Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: Date: Wed, 18 Jan 2012 13:17:06 -0700 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: References: <4F168BF40200002500044900@gw.wicourts.gov> <26230.1326913189@sss.pgh.pa.us> <9539BFEA-F0B8-410F-A56E-E2A3832EB012@elevated-dev.com> To: Rick Dicaire X-Mailer: Apple Mail (2.1084) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail1.sea5 X-Spam-Level: X-Spam-Status: No, score=0.0 required=8.0 tests=none autolearn=disabled version=3.0.4 X-Pg-Spam-Score: -0.0 (/) X-Archive-Number: 201201/92 X-Sequence-Number: 39004 On Jan 18, 2012, at 1:09 PM, Rick Dicaire wrote: > No, I know what the indexes are. The scenario is there's 3 tables in > the db that get clustered. Wanted to know in what order those 3 tables > are reclustered when CLUSTER is exec'd with no args. Ah, I see now. Sorry for the noise. -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice