DB Dump Size - Mailing list pgsql-admin

From
Subject DB Dump Size
Date
Msg-id 326684d8c021f4afb82f8e921f9e0c40@127.0.0.1
Whole thread Raw
Responses Re: DB Dump Size  (Thomas Jacob <jacob@internet24.de>)
List 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.

pgsql-admin by date:

Previous
From: Thomas Jacob
Date:
Subject: Re: Best practice running a shared DB hosting server
Next
From: Thomas Jacob
Date:
Subject: Re: DB Dump Size