Option for pg_dump to dump tables in clustered index order

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-hackers by date

  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