| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why do I have holes in my pages? |
| Date: | 2012-09-20 20:53:58 |
| Message-ID: | 505B8266.3050707@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/*
(assuming this is a linux or similar unix system)..... This will show
how much space is being used by the various directories under the PG
data directory. if pg_xlog is very large, you may have an issue with
wal archiving or something. if pg_log is very large, you may have an
issue with A) too much being logged, and B) nothing cleaning up stale
log files.
how did you arrive at the 2.7TB number? and what file system does
this 6.6TB volume use?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksey Tsalolikhin | 2012-09-20 21:32:15 | Re: Why do I have holes in my pages? |
| Previous Message | Victor Yegorov | 2012-09-20 20:46:38 | Re: Why do I have holes in my pages? |