X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E3C3CD889B for ; Fri, 14 Oct 2005 11:56:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12064-04 for ; Fri, 14 Oct 2005 14:56:23 +0000 (GMT) Received: from mail.androme.com (mail.androme.com [62.58.96.145]) by svr1.postgresql.org (Postfix) with ESMTP id CF273D72AA for ; Fri, 14 Oct 2005 11:56:24 -0300 (ADT) Received: from [127.0.0.1] ([192.168.10.56]) by mail.androme.com (8.12.10/8.12.10) with ESMTP id j9EEuR1R006729 for ; Fri, 14 Oct 2005 16:56:28 +0200 Message-ID: <434FC71B.40608@andromeiberica.com> Date: Fri, 14 Oct 2005 16:56:27 +0200 From: Arnau Rebassa Villalonga Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: help with pg_dump timings References: <1d219a6f0510120636h353fa8f5s134407c004e15096@mail.gmail.com> In-Reply-To: <1d219a6f0510120636h353fa8f5s134407c004e15096@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/182 X-Sequence-Number: 19254 Hi, > Also, what -Z compression level equals the compression of gzip? I've > played with -Z9, but it seems to compress better than gzip (but takes a > bit longer). I haven't done timing measurements but what I have noticed is that if you use the custom format and after you try to compress the resultant file, the size is not reduced that much, so it's not worth to spend time compressing. Cheers -- Arnau