Message-ID: <4F758C45.3000704@gmail.com>
Date: Fri, 30 Mar 2012 12:34:45 +0200
From: Alexander Fortin <alexander.fortin@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: pg_database_size() and actual disk space usage
References: <4F742D3A.8010501@gmail.com>
	<CA+h6AhgGgREbgpt2bobXUzunppWRbgii2TYMSksSbeYouM9Agg@mail.gmail.com>
	<4F743C47.1040907@gmail.com> <4F746282.3060406@innogames.de>
	<4F755EBE.2070908@gmail.com> <4F758796.6090000@innogames.de>
In-Reply-To: <4F758796.6090000@innogames.de>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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/