On Wed, Jan 18, 2012 at 10:08 AM, Kevin Grittner
<Kevin.Grittner@wicourts.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?