Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id BE42A86A54A for ; Wed, 18 Jan 2012 15:17:34 -0400 (AST) Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rnb0j-0006uX-9T for pgsql-admin@postgresql.org; Wed, 18 Jan 2012 19:17:34 +0000 Received: from mail2.sea5.speakeasy.net (mail2.sea5.speakeasy.net [69.17.117.41]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 4EFC93C8050 for ; Wed, 18 Jan 2012 14:17:15 -0500 (EST) Received: (qmail 17968 invoked from network); 18 Jan 2012 19:17:15 -0000 Received: by simscan 1.4.0 ppid: 2636, pid: 25115, t: 1.2354s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from unknown (HELO [192.168.2.16]) (sribe@elevated-dev.com@[63.227.17.6]) (envelope-sender ) by mail2.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 18 Jan 2012 19:17:14 -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: <26230.1326913189@sss.pgh.pa.us> Date: Wed, 18 Jan 2012 12:17:12 -0700 Cc: Rick Dicaire , "[ADMIN]" Content-Transfer-Encoding: quoted-printable Message-Id: <9539BFEA-F0B8-410F-A56E-E2A3832EB012@elevated-dev.com> References: <4F168BF40200002500044900@gw.wicourts.gov> <26230.1326913189@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.1084) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail2.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/90 X-Sequence-Number: 39002 On Jan 18, 2012, at 11:59 AM, Tom Lane wrote: > AFAIR there is no specified order. It probably just seqscans = pg_class, > so whatever physical order those tuples happen to have today is it. I'm pretty sure he meant: "in the case when CLUSTER was issued in the = past to cluster the table on some index, but was not documented, how do = I now find out what that index was". --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice