Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ECFA164FD29 for ; Mon, 18 Aug 2008 11:57:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15443-07 for ; Mon, 18 Aug 2008 11:57:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web25806.mail.ukl.yahoo.com (web25806.mail.ukl.yahoo.com [217.12.10.191]) by postgresql.org (Postfix) with SMTP id 2AD3564FD05 for ; Mon, 18 Aug 2008 11:57:44 -0300 (ADT) Received: (qmail 84225 invoked by uid 60001); 18 Aug 2008 14:57:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=lab7GTImYsnTToFRM1tANIa0iVakcTawK5oDg8VEnvk9AgYnuhlS3w+MoRzIGN3fLRn06vdLs+r0bwuGbrFBkNA4QeucqXI1S3lsgKVxurSk/8a8p3RqD/r/9koG5LGF3Arl5SSar9OpgVAY2SGmqtDcEDg6SEHocCkcn1sO+V0=; X-YMail-OSG: nCQ9iYEVM1nM3faK6t5jlEeHooX6CjycffDLPLZSryWzhgx9wB2vEKBnH8TL2CnpzUFE8t.wGM.YZk6gYAHvD0Ujy9WvC4Uwlw8uoEqa2C4g56Oimsj0HbUjD2wwpZliNmo_VEFuo5uzIPQLDmqGY3w- Received: from [213.83.65.106] by web25806.mail.ukl.yahoo.com via HTTP; Mon, 18 Aug 2008 14:57:42 GMT X-Mailer: YahooMailWebService/0.7.218.2 Date: Mon, 18 Aug 2008 14:57:42 +0000 (GMT) From: Glyn Astill Reply-To: glynastill@yahoo.co.uk Subject: Re: DB Dump Size To: pgsql-admin@postgresql.org In-Reply-To: <4b73e5d30df8b0e1a0939291a5a16c31@127.0.0.1> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Message-ID: <195974.83929.qm@web25806.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/73 X-Sequence-Number: 29918 > I am also curious as to why an SQL dump from the production > server would > come out to 2.8G but a dump of an exact replica on a test > box would come > out to 3.0G. What determines the size and makeup of an SQL > dump? Why not repeat the dump without any compression then compare them with a fi= le comparison tool? =0A=0ASend instant messages to your online friends http://uk.messenger.yaho= o.com