Skip site navigation (1) Skip section navigation (2)

Re: CLUSTER command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rick Dicaire <kritek(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: CLUSTER command
Date: 2012-01-18 18:59:49
Message-ID: 26230.1326913189@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Rick Dicaire <kritek(at)gmail(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Scott RibeDate: 2012-01-18 19:17:12
Subject: Re: CLUSTER command
Previous:From: Rick DicaireDate: 2012-01-18 18:54:10
Subject: Re: CLUSTER command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group