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

From Scott Marlowe
Subject Re: Large files in main/base
Date
Msg-id AANLkTimJ68WfQLz9oza9QdwviWEENKILLB3iA2xqs3yi@mail.gmail.com
Whole thread Raw
In response to Large files in main/base  ("Henry, Frank" <frank.henry@barco.com>)
Responses Re: Large files in main/base  (Tom Lane <tgl@sss.pgh.pa.us>)
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.

And it is?  So close to telling us.

>
> My Questions:
> What is it?

Why don't you tell us?

pgsql-admin by date:

Previous
From: "Ezhil Sundaram"
Date:
Subject: Postgresql shared_buffer and SHMMAX configuration.
Next
From: Tom Lane
Date:
Subject: Re: Large files in main/base