Re: Why do I have holes in my pages? - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject Re: Why do I have holes in my pages?
Date
Msg-id CA+jMWofYmBeby29eJ-2A8Mh766TG6eqjvihMpXgei=tgOW77mQ@mail.gmail.com
Whole thread Raw
In response to Re: Why do I have holes in my pages?  (John R Pierce <pierce@hogranch.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Why do I have holes in my pages?
Next
From: Craig Ringer
Date:
Subject: Re: Using psql -f to load a UTF8 file