Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER command - Mailing list pgsql-admin

From Tom Lane
Subject Re: CLUSTER command
Date
Msg-id 26230.1326913189@sss.pgh.pa.us
Whole thread Raw
In response to Re: CLUSTER command  (Rick Dicaire <kritek@gmail.com>)
Responses Re: CLUSTER command  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Rick Dicaire
Date:
Subject: Re: CLUSTER command
Next
From: Scott Ribe
Date:
Subject: Re: CLUSTER command