Re: GZIP of pre-zipped output - Mailing list pgsql-performance

From Craig Ringer
Subject Re: GZIP of pre-zipped output
Date
Msg-id 4BA6DA08.4010201@postnewspapers.com.au
Whole thread Raw
In response to GZIP of pre-zipped output  (Dave Crooke <dcrooke@gmail.com>)
Responses Re: GZIP of pre-zipped output
List pgsql-performance
On 22/03/2010 1:04 AM, Dave Crooke wrote:
> If you are really so desparate to save a couple of GB that you are
> resorting to -Z9 then I'd suggest using bzip2 instead.
>
> bzip is designed for things like installer images where there will be
> massive amounts of downloads, so it uses a ton of cpu during
> compression, but usually less than -Z9 and makes a better result.

bzip2 doesn't work very well on gzip'd (deflated) data, though. For good
results, you'd want to feed it uncompressed data, which is a bit of a
pain when the compression is part of the PDF document structure and when
you otherwise want the PDFs to remain compressed.

Anyway, if you're going for extreme compression, these days 7zip is
often a better option than bzip2.

--
Craig Ringer

pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Re: mysql to postgresql, performance questions
Next
From: Scott Marlowe
Date:
Subject: Re: GZIP of pre-zipped output