pg_dump custom format and pigz

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump custom format and pigz
Date: 2009-10-23 12:48:58
Message-ID: C4DAC901169B624F933534A26ED7DF31010A5349@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

I'm using pg_dump intensively, and until now using the plaintext format
which allows me to pipe the output to pigz (http://zlib.net/pigz/)
This is the fastest way I've found to generate compressed backups.

(These backups are very rarely used)

I would like to switch to the custom format in order to take advantage
of the parallel restore enhancement, but this would force me to give
pigz up, hence loosing performances with pg_dump.

Is there a way to combine the custom format with pigz?

feature request ?

best regards,

Marc Mamin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tino Schwarze 2009-10-23 13:10:42 Re: pg_dump custom format and pigz
Previous Message Joshua D. Drake 2009-10-22 23:56:52 Re: select actual data size for a relation?