pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: steve@outtalimits.com.au
To: pgsql-admin@postgresql.org
Subject: DB Dump Size
Date: Thu, 14 Aug 2008 12:06:53 +1000
Message-ID: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1> (raw)

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.



view thread (8+ messages)  latest in thread

Message-ID: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1>
Permalink:  ../326684d8c021f4afb82f8e921f9e0c40@127.0.0.1/
Also on:    postgresql.org/message-id/326684d8c021f4afb82f8e921f9e0c40@127.0.0.1

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: steve@outtalimits.com.au
  Subject: Re: DB Dump Size
  In-Reply-To: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox