From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | CLUSTER all tables |
Date: | 2002-08-30 23:02:47 |
Message-ID: | Pine.LNX.4.44.0208301854170.17098-200000@cm-lcon1-46-187.cm.vtr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Hello,
This is a first attempt at CLUSTER ALL. It works in every way I've
tested, but maybe I'm missing something.
What it does:
- if CLUSTER is called with no arguments, cluster all indexes that have
indisclustered set (in the current database). There's no "ALL"
argument: that's just pollution IMHO.
- Gets a list of such indexes (checking ownership of each) and passes
them one by one to the standard cluster routine (modified a little so
it accepts OIDs of table and index, not names).
- Not much else... (no regression test nor documentation yet).
I don't know if I will be able to do the REINDEX all thing now that beta
is almost here.
Please review; I may be doing something stupid.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Aprender sin pensar es inutil; pensar sin aprender, peligroso" (Confucio)
Attachment | Content-Type | Size |
---|---|---|
cluster-all.patch | text/plain | 13.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-08-31 00:23:18 | Re: revised patch for PL/PgSQL table functions |
Previous Message | John Gray | 2002-08-30 22:41:35 | Re: Visibility regression test |