Database size - Mailing list pgsql-admin

From Andrew Janian
Subject Database size
Date
Msg-id CE10B12929C8584090A3A10DCA0DAE710D1E6E68@exchstl1.scottrade.com
Whole thread Raw
List pgsql-admin
I have recently inherited a Postgres 7.2 DB.  I noticed that the size of the database on the disk is about 100 times
thesize of the nightly dumps that get done.  I looked into it and realized that after millions of rows are deleted each
monththere was no vacuum full performed on the DB.  I also noticed that the disk space was not recovered to the OS.  I
assumedthat was because there was no vacuum full being performed.  I am currently performing a vacuum full and noticing
thatno space is being recovered.  Is it normal for a DB to be that much bigger than it's dumps? 

Thanks,

Andrew Janian


pgsql-admin by date:

Previous
From: "Monica Libero"
Date:
Subject:
Next
From: Chester Kustarz
Date:
Subject: Re: pg_class / missing tables