Skip site navigation (1) Skip section navigation (2)

Re: pg_database_size() and actual disk space usage

From: Alexander Fortin <alexander(dot)fortin(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_database_size() and actual disk space usage
Date: 2012-03-30 10:34:45
Message-ID: 4F758C45.3000704@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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/

In response to

Responses

pgsql-admin by date

Next:From: Vladimir RusinovDate: 2012-03-30 10:39:16
Subject: Re: pg_database_size() and actual disk space usage
Previous:From: Bernhard SchraderDate: 2012-03-30 10:14:46
Subject: Re: pg_database_size() and actual disk space usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group