DB Dump Size

From: <steve(at)outtalimits(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: DB Dump Size
Date: 2008-08-14 02:06:53
Message-ID: 326684d8c021f4afb82f8e921f9e0c40@127.0.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Jacob 2008-08-14 08:30:07 Re: DB Dump Size
Previous Message Thomas Jacob 2008-08-13 15:48:10 Re: Best practice running a shared DB hosting server