Difference in DB size with dump and pg_database_size

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Difference in DB size with dump and pg_database_size
Date: 2011-07-05 08:38:57
Message-ID: 9f0dc5a42405f1742e1a28269a94d50e@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
any one can explain me why I have difference between db size when I
dump db, I see it's 5G and when I run SELECT
pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize; on my DB
postgresql return: 10 GB

I run vacuum on db every night. Why is that huge difference in size ?

--
Regards,
Condor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2011-07-05 08:43:38 Re: Difference in DB size with dump and pg_database_size
Previous Message Albe Laurenz 2011-07-05 08:19:17 Re: cannot "make USE_PGXS=1" b/c no pgxs.mk exists