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

Re: CLUSTER command

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rick Dicaire <kritek(at)gmail(dot)com>, "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: CLUSTER command
Date: 2012-01-18 19:17:12
Message-ID: 9539BFEA-F0B8-410F-A56E-E2A3832EB012@elevated-dev.com (view raw or flat)
Thread:
Lists: pgsql-admin
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".

-- 
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice





In response to

Responses

pgsql-admin by date

Next:From: Rick DicaireDate: 2012-01-18 20:09:09
Subject: Re: CLUSTER command
Previous:From: Tom LaneDate: 2012-01-18 18:59:49
Subject: Re: CLUSTER command

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