By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

PGDATA directory 50% smaller then size give by select pg_database_size()

P: 1
What are the high level reasons for this assuming
we just have one database call it "test", in addition to the postgres one.

If I reload "test" from a fresh pg_dump will the
sizes be closer. Is this purely due table bloat?

What exactly is included in pg_database_size?

I could not find any documentation on discrepancies
between the actual size of the data directory and
that reported by postgres.

Thanks in advance.
Aug 5 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.