[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: pg_database_size() and actual disk space usage



On 3/30/12 12:14 PM, Bernhard Schrader wrote:
> i hope this will help you.

Thanks Bernhard, I'll check the thread right now. In the meanwhile I've
noticed this strange behavior too and I was already going to post it,
maybe it's related to what you're suggesting:

# 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.

-- 
Alexander Fortin
http://about.me/alexanderfortin/

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

Powered by Linux