Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 41F17634E05 for ; Sun, 21 Mar 2010 23:47:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68185-02 for ; Mon, 22 Mar 2010 02:46:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by mail.postgresql.org (Postfix) with ESMTP id 8EA7163131C for ; Sun, 21 Mar 2010 23:46:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 3D3F3AE5C7; Mon, 22 Mar 2010 10:45:15 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail2.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id GTydtczfSxBa; Mon, 22 Mar 2010 10:45:10 +0800 (WST) Received: from [10.1.1.2] (124-148-241-102.dyn.iinet.net.au [124.148.241.102]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 26914AE5C5; Mon, 22 Mar 2010 10:45:10 +0800 (WST) Message-ID: <4BA6DA08.4010201@postnewspapers.com.au> Date: Mon, 22 Mar 2010 10:46:32 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3 MIME-Version: 1.0 To: Dave Crooke CC: David Newall , pgsql-performance@postgresql.org, robertmhaas@gmail.com, Tom Lane Subject: Re: GZIP of pre-zipped output References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201003/264 X-Sequence-Number: 38089 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