From: Alexander Fortin <alexander.fortin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_database_size() and actual disk space usage
Date: Fri, 30 Mar 2012 12:34:45 +0200
Message-ID: <4F758C45.3000704@gmail.com> (raw)
In-Reply-To: <4F758796.6090000@innogames.de>
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>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alexander.fortin@gmail.com
Subject: Re: pg_database_size() and actual disk space usage
In-Reply-To: <4F758C45.3000704@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox