Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9D268650259 for ; Wed, 13 Aug 2008 23:18:02 -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 90310-09 for ; Wed, 13 Aug 2008 23:17:53 -0300 (ADT) X-Greylist: delayed 00:10:55.717424 by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out4.iinet.net.au (outbound.icp-qv1-irony-out4.iinet.net.au [203.59.1.150]) by postgresql.org (Postfix) with ESMTP id 6786465024D for ; Wed, 13 Aug 2008 23:17:58 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AvEDAOgvo0h8q5Nq/2dsb2JhbACLSIUxpTuBVQ X-IronPort-AV: E=Sophos;i="4.32,204,1217779200"; d="scan'208";a="259128530" Received: from unknown (HELO mail.outtalimits.com.au) ([124.171.147.106]) by outbound.icp-qv1-irony-out4.iinet.net.au with ESMTP; 14 Aug 2008 10:06:53 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id 7890A2B6405C for ; Thu, 14 Aug 2008 12:06:53 +1000 (EST) MIME-Version: 1.0 Date: Thu, 14 Aug 2008 12:06:53 +1000 From: To: pgsql-admin@postgresql.org Subject: DB Dump Size Message-ID: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1> X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.2a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit 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/53 X-Sequence-Number: 29898 Hi all, I am curious as to why a pg dump of database "name" is 2.9gig. But is measured at 1.66gig by: SELECT pg_database_size(pg_database.datname) AS db_size FROM pg_database WHERE pg_database.datname='name' ; This dump was about 1 gig around 12 months ago. I am performing a monthly vacuum full on the database and a nightly vacuum all Thanks. Steve.