| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Henry, Frank" <frank(dot)henry(at)barco(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Large files in main/base |
| Date: | 2010-07-09 18:12:43 |
| Message-ID: | AANLkTimwmBRruoPZ51oEoZWgcOYOmS2HhKdZCiBIeA1n@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank <frank(dot)henry(at)barco(dot)com> wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely reaching 3mb.
>
> After looking around, I found one file with about 580 mb. From the
> contents I have the feeling it is some kind of changelog or similar.
pg_clog? If that's growing you've got a possible problem with a long
running query.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2010-07-09 19:23:23 | Re: High Availability: Hot Standby vs. Warm Standby |
| Previous Message | Joshua D. Drake | 2010-07-09 18:05:23 | Re: Large files in main/base |