Re: pg_dump custom format and pigz

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump custom format and pigz
Date: 2009-10-23 13:10:42
Message-ID: 20091023131042.GA3252@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

Hi Marc,

On Fri, Oct 23, 2009 at 02:48:58PM +0200, Marc Mamin wrote:

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

You might add pigz as a post-processing step and disabling compression in
pg_dump.

HTH,

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.tisc.de

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mamin 2009-10-23 13:52:16 Re: pg_dump custom format and pigz
Previous Message Marc Mamin 2009-10-23 12:48:58 pg_dump custom format and pigz