Re: pg_database_size() and actual disk space usage

On 3/30/12 12:14 PM, Bernhard Schrader wrote:

# df -h /var/lib/postgresql

Filesystem            Size  Used Avail Use% Mounted on
/dev/md_d0            128G   44G   85G  35% /var/lib/postgresql

# /etc/init.d/postgresql stop
 * Stopping PostgreSQL 9.1 database server
  ...done.

# df -h /var/lib/postgresql
Filesystem            Size  Used Avail Use% Mounted on
/dev/md_d0            128G   36G   93G  28% /var/lib/postgresql


so, with Postgres shut down, numbers get back to make sense to me.