| From: | Timothy Garnett <tgarnett(at)panjiva(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Option for pg_dump to dump tables in clustered index order |
| Date: | 2012-02-22 23:17:31 |
| Message-ID: | CAPcyiQ2E+41BYvUgiGW79TcHmGY3tuym41hKHvUWWrzKX=pEmA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi All,
Having pg_dump dump tables in clustered index order is something we've
found we've needed a fair number of times (for ex. when copying a large
logging tables or sets of tables out of one database where the order is not
maintained into another for running a bunch of backend analysis) as it
saves us the clustering step which is often longer then the copy step
itself.
I wanted to gauge the interest in adding an option for this to pg_dump. A
(not production ready) patch that we've been using off of the 9.1.2 tag to
implement this is attached or can be viewed
here<https://github.com/tgarnett/postgres/commit/d4412aa4047e7a0822ee93fa47a1c0d282cb7925>.
It adds a --cluster-order option to pg_dump. If people have any
suggestions on better ways of pulling out the order clause or other
improvements that would be great too.
Tim
| Attachment | Content-Type | Size |
|---|---|---|
| d4412aa4047e7a0822ee93fa47a1c0d282cb7925.patch | text/x-patch | 9.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2012-02-22 23:17:53 | Re: 16-bit page checksums for 9.2 |
| Previous Message | Robert Haas | 2012-02-22 22:57:05 | Re: WIP: proof of concept patch for fixing quantified regex backrefs |