Postgres Pro
Downloads
Home   >   mailing lists

Difference in DB size with dump and pg_database_size - Mailing list pgsql-general

From Condor
Subject Difference in DB size with dump and pg_database_size
Date
Msg-id 9f0dc5a42405f1742e1a28269a94d50e@stz-bg.com
Whole thread Raw
Responses Re: Difference in DB size with dump and pg_database_size
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: cannot "make USE_PGXS=1" b/c no pgxs.mk exists
Next
From: Magnus Hagander
Date:
Subject: Re: Difference in DB size with dump and pg_database_size