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 |
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! |