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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2012-01-18 19:17:12 Re: CLUSTER command
Previous Message Rick Dicaire 2012-01-18 18:54:10 Re: CLUSTER command