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

Re: CLUSTER command

From: Rick Dicaire <kritek(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: CLUSTER command
Date: 2012-01-18 18:54:10
Message-ID: CA+Cc--fnt=i34g1k04=pNAqy-u2u-Ab-yoeWhCuO7Wh72heRjg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Jan 18, 2012 at 10:08 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> Also, I've been tasked with finding and listing all the tables
>> that get CLUSTER'd when CLUSTER with no args is executed,
>
> http://www.postgresql.org/docs/8.1/interactive/catalog-pg-index.html

select relname as table from pg_class join pg_index on pg_class.oid =
pg_index.indrelid where indisclustered = 't';
select relname as index from pg_class join pg_index on pg_class.oid =
pg_index.indexrelid where indisclustered = 't';

Thanks, this gets me the list.

How do I determine in what order tables are clustered when CLUSTER is
executed with no args?

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2012-01-18 18:59:49
Subject: Re: CLUSTER command
Previous:From: Kevin GrittnerDate: 2012-01-18 15:08:04
Subject: Re: CLUSTER command

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