| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Fortin | 2012-03-30 10:34:45 | Re: pg_database_size() and actual disk space usage |
| Previous Message | Alexander Fortin | 2012-03-30 07:20:30 | Re: pg_database_size() and actual disk space usage |