X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AE7C111F610C for ; Tue, 25 Apr 2006 17:53:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 33410-01 for ; Tue, 25 Apr 2006 17:53:15 -0300 (ADT) X-Greylist: delayed 00:09:08.877037 by SQLgrey- Received: from morpheus.bostonstock.com (unknown [192.233.205.44]) by postgresql.org (Postfix) with ESMTP id 8BF3011F61C2 for ; Tue, 25 Apr 2006 17:53:10 -0300 (ADT) Received: by MORPHEUS with Internet Mail Service (5.5.2653.19) id <2R02AWD4>; Tue, 25 Apr 2006 16:39:41 -0400 Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2584@MORPHEUS> From: "mcelroy, tim" To: "'pgsql-admin@postgresql.org'" Subject: dbsize & pg_dump Date: Tue, 25 Apr 2006 16:39:40 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C668A8.601633A0" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/269 X-Sequence-Number: 21438 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C668A8.601633A0 Content-Type: text/plain; charset="iso-8859-1" Good afternoon, Probably an easy question but why are the file sizes differ so much between these two tools? For example: A backup using pg_dump of our largest DB creates a file 384MB in size Using the following SQL code utilizing dbsize I get the following: FIX1=# SELECT D1.pg_size_pretty AS "FIX1_DB_SIZE" FIX1-# FROM (SELECT pg_size_pretty(database_size('FIX1'))) D1; FIX1_DB_SIZE -------------- 3832 MB (1 row) Is it safe to assume that pg_dump does a compression of the data? Thanks Tim ------_=_NextPart_001_01C668A8.601633A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable dbsize & pg_dump

Good = afternoon,

Probably an easy question but why are the file sizes = differ so much = between these two tools?

For = example: 

A = backup using pg_dump of our largest DB creates a file 384MB in size

Using = the following SQL code utilizing dbsize I get the following:

FIX1=3D# SELECT D1.pg_size_pretty AS = "FIX1_DB_SIZE"

FIX1-# = FROM (SELECT pg_size_pretty(database_size('FIX1'))) D1;

 FIX1_DB_SIZE

--------------

 3832 MB

(1 = row)

Is it safe to assume that pg_dump does a compression of the data?

Thanks

Tim

------_=_NextPart_001_01C668A8.601633A0--