On Mon, Aug 11, 2008 at 10:30 AM, Joao Ferreira gmail <joao.miguel.c.ferreira@xxxxxxxxx> wrote: > Hello all, > > I'm finding it very strange that my pg takes 9Giga on disk but > pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed > yesterday. > > Is this normal ? Should I be worried ? It really depends. If you've got a lot of indexes then maybe that's normal. But most the time you don't see more than about 4 times the space used in the db as in the dump. It's likely you've got index bloat. If you reload a pg_dump of the database in question into another server how much space does that take up? Look into using CLUSTER or REINDEX to fix the space usage.
