Option for pg_dump to dump tables in clustered index order
Timothy Garnett <tgarnett@panjiva.com>
From: Timothy Garnett <tgarnett@panjiva.com>
To: pgsql-hackers@postgresql.org
Date: 2012-02-22T23:17:31Z
Lists: pgsql-hackers
Attachments
- d4412aa4047e7a0822ee93fa47a1c0d282cb7925.patch (text/x-patch) patch
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