Re: pg_database_size() and actual disk space usage

Поиск
Список
Период
Сортировка
От Bernhard Schrader
Тема Re: pg_database_size() and actual disk space usage
Дата
Msg-id 4F758796.6090000@innogames.de
обсуждение исходный текст
Ответ на Re: pg_database_size() and actual disk space usage  (Alexander Fortin <alexander.fortin@gmail.com>)
Ответы Re: pg_database_size() and actual disk space usage  (Alexander Fortin <alexander.fortin@gmail.com>)
Re: pg_database_size() and actual disk space usage  (Alexander Fortin <alexander.fortin@gmail.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alexander Fortin
Дата:
Сообщение: Re: pg_database_size() and actual disk space usage
Следующее
От: Alexander Fortin
Дата:
Сообщение: Re: pg_database_size() and actual disk space usage