Re: Large files in main/base - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Large files in main/base
Date
Msg-id AANLkTimwmBRruoPZ51oEoZWgcOYOmS2HhKdZCiBIeA1n@mail.gmail.com
Whole thread Raw
In response to Large files in main/base  ("Henry, Frank" <frank.henry@barco.com>)
List pgsql-admin
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank <frank.henry@barco.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.

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Large files in main/base
Next
From: Brad Nicholson
Date:
Subject: Re: High Availability: Hot Standby vs. Warm Standby