On Wed, Jan 18, 2012 at 10:08 AM, Kevin Grittner
>> 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 Lane||Date: 2012-01-18 18:59:49|
|Subject: Re: CLUSTER command |
|Previous:||From: Kevin Grittner||Date: 2012-01-18 15:08:04|
|Subject: Re: CLUSTER command|