From: Bernhard Schrader <bernhard.schrader@innogames.de>
To: pgsql-admin@postgresql.org
Subject: Re: pg_database_size() and actual disk space usage
Date: Fri, 30 Mar 2012 12:14:46 +0200
Message-ID: <4F758796.6090000@innogames.de> (raw)
In-Reply-To: <4F755EBE.2070908@gmail.com>
References: <4F742D3A.8010501@gmail.com>
<CA+h6AhgGgREbgpt2bobXUzunppWRbgii2TYMSksSbeYouM9Agg@mail.gmail.com>
<4F743C47.1040907@gmail.com>
<4F746282.3060406@innogames.de>
<4F755EBE.2070908@gmail.com>
On 03/30/2012 09:20 AM, Alexander Fortin wrote:
> On 3/29/12 3:24 PM, Bernhard Schrader wrote:
>> Hi,
>>
>> which filesystem do you use, and which kernel is running?
>
> Hi Bernhard,
>
> it's XFS on Ubuntu server 11.10, Kernel is 3.0.0-16-virtual (m1.large
> Ec2 instances)
>
Ok, well with Kernel 2.6.38 xfs introduced a new "feature" (i think it
was dynamic preallocation) which caused some strange behaviour for me
also, i discussed it on xfs mailinglist, maybe this gives you some hints
of solving your different diskusages.
http://old.nabble.com/Problems-with-filesizes-on-different-Kernels-td33342207.html#a33342207
At the end was the solution for me, but you can first check what i
posted in the first message - testing base directory with du -sh and du
--apparent-size -h
i hope this will help you.
regards
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: bernhard.schrader@innogames.de
Subject: Re: pg_database_size() and actual disk space usage
In-Reply-To: <4F758796.6090000@innogames.de>
* 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