On Wed, Jan 18, 2012 at 10:08 AM, Kevin Grittner <kevin.gritt...@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? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
