Re: Why do I have holes in my pages?

Поиск
Список
Период
Сортировка
От Aleksey Tsalolikhin
Тема Re: Why do I have holes in my pages?
Дата
Msg-id CA+jMWofYmBeby29eJ-2A8Mh766TG6eqjvihMpXgei=tgOW77mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why do I have holes in my pages?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
On Thu, Sep 20, 2012 at 1:53 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 09/20/12 1:34 PM, Aleksey Tsalolikhin wrote:
>>
>> Right on.  I got that out of my pgstatspack report.
>>
>> \l+ in psql tells me the same thing - 400 GB
>
>
> it might be interesting to see the output of...
>
>     du -hs $PGDATA/*

Well, that was it!  Thanks, John!

2.3T    /data/backups
400G    /data/base

We store our pg_dumps on the same filesystem (they are copied off to
another server but we don't delete them) so it swelled the filesystem
size as reported by "df".

Sorry about that.  And thanks for the help!

Aleksey


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Why do I have holes in my pages?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Using psql -f to load a UTF8 file