Re: database size much bigger than tablespaces on filesystem

Rob Audenaerde <Rob.Audenaerde@Valuecare.nl> writes:
>>> I check te database size like this:
>>> select pg_size_pretty(pg_database_size('database'))
>>> 595 GB

>> You should also check the space held in $PGDATA/base.

> I did. It is only 320 MB.

Bizarre.  Try breaking the results down table-by-table to see if you can
find where the discrepancy is.

            regards, tom lane