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: (view raw or whole 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,

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


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-2015 The PostgreSQL Global Development Group