Re: Is a plan for lmza commpression in pg_dump - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Is a plan for lmza commpression in pg_dump
Date
Msg-id 498EF4FB.2080605@dunslane.net
Whole thread Raw
In response to Re: Is a plan for lmza commpression in pg_dump  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers

Martijn van Oosterhout wrote:
>
> Why don't we just add an option to pg_dump --use-compress-program, just
> like tar and then people can use their "compression algorithm of the
> week" and we don't need to care about the licence or anything.
>
> It's not like the case of TOAST where it actually needs to be builtin.
> Tar doesn't have any compression builtin, yet you don't see many
> uncompressed tar files...
>
>
>   

tar compresses/decompresses the whole archive via a single pipe. pg_dump 
compresses individual data members. If the compression isn't builtin it 
will make life much more difficult, and probably make parallel restore 
as well as some other operations well nigh impossible.

cheers

andrew




pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: Is a plan for lmza commpression in pg_dump
Next
From: Tom Lane
Date:
Subject: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS