| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-01-18 18:59:49 | Re: CLUSTER command |
| Previous Message | Kevin Grittner | 2012-01-18 15:08:04 | Re: CLUSTER command |