Dump CLUSTER in pg_dump

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Dump CLUSTER in pg_dump
Date: 2003-02-27 06:24:02
Message-ID: 03c301c2de28$d2164c50$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Currently, the fact that an index is clustered is not dumped. Unfortunately
the only way of dumping this information is with a cluster statement itself.

One possible improvement would be to sort clustered indexes first and dump
them first, that way the cluster operation does not have to do so much
reindexing.

Example output:

--
-- TOC entry 7 (OID 17078)
-- Name: test_idx; Type: INDEX; Schema: public; Owner: chriskl
--

CREATE INDEX test_idx ON test USING btree (a);

CLUSTER test_idx ON test;

Attachment Content-Type Size
cluster.txt text/plain 3.9 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-02-27 13:50:48 Re: XML ouput for psql
Previous Message Christopher Kings-Lynne 2003-02-27 05:09:18 Actual patch for last mail!