Re: Cluster all tables in database to PK index

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cluster all tables in database to PK index
Date: 2007-01-11 15:47:42
Message-ID: C1CBAA2E.5FA0C%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Besides writing a script that looks through the DDL of all tables, and
> CLUSTERs all tables with PK constraints, is there a quicker way?

Is this really a sensible thing to do? As often as not, you want to cluster
on foreign keys...

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message SunWuKung 2007-01-11 17:19:08 crosstab - pivot - transpose
Previous Message Russell Smith 2007-01-11 15:05:45 Re: Problems With VIEWS