Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB8B82E2E71 for ; Thu, 15 Nov 2007 12:11:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48187-03 for ; Thu, 15 Nov 2007 12:11:44 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id DA1D62E2E6F for ; Thu, 15 Nov 2007 12:11:43 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IshJf-0007DI-Cj for pgsql-sql@postgresql.org; Thu, 15 Nov 2007 11:11:43 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 2E299504FC; Thu, 15 Nov 2007 11:11:38 -0500 (EST) Date: Thu, 15 Nov 2007 11:11:38 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Is there anything special about pg_dump's compression? Message-ID: <20071115161138.GI20228@crankycanuck.ca> References: <473C6E58.5010102@verizon.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <473C6E58.5010102@verizon.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/80 X-Sequence-Number: 29608 On Thu, Nov 15, 2007 at 11:05:44AM -0500, Jean-David Beyer wrote: > Does pg_dump's compression do anything really special that it is not likely > the tape drive already does? The drive claims 2:1 compression for average > data (e.g., not already compressed stuff like .jpeg files). It's zlib, if I recall correctly. So probably not. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke