Rob Audenaerde <Rob.Audenaerde@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin