Skip site navigation (1) Skip section navigation (2)

Re: DB Dump Size

From: Thomas Jacob <jacob(at)internet24(dot)de>
To: steve(at)outtalimits(dot)com(dot)au
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DB Dump Size
Date: 2008-08-14 08:30:07
Message-ID: 20080814083003.GA456@internet24.de (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Aug 14, 2008 at 12:06:53PM +1000, steve(at)outtalimits(dot)com(dot)au wrote:
> 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.

Which options do you use for pg_dump? And what version of PosgreSQL are
you running?

In general it's not that strange for an uncompressed
dump to be larger than the database size, plain SQL
dumps are much less space efficient than a DBMS can
be when it stores the data on disk. But of course, there
also indices to consider.

Have you tried pg_dump -Fc?

> I am performing a monthly vacuum full on the database and a nightly vacuum
> all

That should only impact the pg_database_size.

In response to

Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2008-08-14 18:45:02
Subject: New postgres installation
Previous:From: steveDate: 2008-08-14 02:06:53
Subject: DB Dump Size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group