| From: | Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why do I have holes in my pages? |
| Date: | 2012-09-20 21:32:15 |
| Message-ID: | CA+jMWofYmBeby29eJ-2A8Mh766TG6eqjvihMpXgei=tgOW77mQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 20, 2012 at 1:53 PM, John R Pierce <pierce(at)hogranch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-09-21 01:21:36 | Re: Using psql -f to load a UTF8 file |
| Previous Message | John R Pierce | 2012-09-20 20:53:58 | Re: Why do I have holes in my pages? |