pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: Dave Crooke <dcrooke@gmail.com>
Cc: David Newall <postgresql@davidnewall.com>
Cc: pgsql-performance@postgresql.org, robertmhaas@gmail.com, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: GZIP of pre-zipped output
Date: Mon, 22 Mar 2010 10:46:32 +0800
Message-ID: <4BA6DA08.4010201@postnewspapers.com.au> (raw)
In-Reply-To: <ca24673e1003211004l68237f72r101eb04082f8e288@mail.gmail.com>
References: <ca24673e1003211004l68237f72r101eb04082f8e288@mail.gmail.com>

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



view thread (3+ messages)  latest in thread

Message-ID: <4BA6DA08.4010201@postnewspapers.com.au>
Permalink:  ../4BA6DA08.4010201@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4BA6DA08.4010201@postnewspapers.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig@postnewspapers.com.au, dcrooke@gmail.com, postgresql@davidnewall.com, tgl@sss.pgh.pa.us
  Subject: Re: GZIP of pre-zipped output
  In-Reply-To: <4BA6DA08.4010201@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox