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

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 (view raw or flat)
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

pgsql-admin by date

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

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