Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 5C2C086A54A
	for <pgsql-admin@postgresql.org>; Wed, 18 Jan 2012 15:00:06 -0400 (AST)
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1Rnajr-0006Wo-T2
	for pgsql-admin@postgresql.org; Wed, 18 Jan 2012 19:00:05 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q0IIxnEw026231;
	Wed, 18 Jan 2012 13:59:49 -0500 (EST)
To: Rick Dicaire <kritek@gmail.com>
cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-admin@postgresql.org
Subject: Re: CLUSTER command 
In-reply-to: 
 <CA+Cc--fnt=i34g1k04=pNAqy-u2u-Ab-yoeWhCuO7Wh72heRjg@mail.gmail.com>
References: 
 <CA+Cc--epWFt+SedYGu8bFwX_T-eRLoapDUq5FeGdDEbTWj08bA@mail.gmail.com>
	<4F168BF40200002500044900@gw.wicourts.gov>
	<CA+Cc--fnt=i34g1k04=pNAqy-u2u-Ab-yoeWhCuO7Wh72heRjg@mail.gmail.com>
Comments: In-reply-to Rick Dicaire <kritek@gmail.com>
	message dated "Wed, 18 Jan 2012 13:54:10 -0500"
Date: Wed, 18 Jan 2012 13:59:49 -0500
Message-ID: <26230.1326913189@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201201/89
X-Sequence-Number: 39001

Rick Dicaire <kritek@gmail.com> writes:
> How do I determine in what order tables are clustered when CLUSTER is
> executed with no args?

AFAIR there is no specified order.  It probably just seqscans pg_class,
so whatever physical order those tuples happen to have today is it.

			regards, tom lane