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

Re: pg_database_size() and actual disk space usage

From: Bernhard Schrader <bernhard(dot)schrader(at)innogames(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_database_size() and actual disk space usage
Date: 2012-03-30 10:14:46
Message-ID: 4F758796.6090000@innogames.de (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Alexander FortinDate: 2012-03-30 10:34:45
Subject: Re: pg_database_size() and actual disk space usage
Previous:From: Alexander FortinDate: 2012-03-30 07:20:30
Subject: Re: pg_database_size() and actual disk space usage

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