Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 7D3B5632EB8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  9 Jul 2010 15:05:36 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 69658-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  9 Jul 2010 18:05:28 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 48511632E0D
	for <pgsql-admin@postgresql.org>; Fri,  9 Jul 2010 15:05:29 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id 7B8BB348037;
	Fri,  9 Jul 2010 11:05:28 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at commandprompt.com
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id 3jdnIZl0MOC7; Fri,  9 Jul 2010 11:05:25 -0700 (PDT)
Received: from [192.168.1.10] (or-69-34-217-90.sta.embarqhsd.net
	[69.34.217.90])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 4355D348036;
	Fri,  9 Jul 2010 11:05:25 -0700 (PDT)
Subject: Re: Large files in main/base
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Henry, Frank" <frank.henry@barco.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <642070EA75A1664C93E07528705FD2C404A39988@KARMEX02.barco.com>
References: <642070EA75A1664C93E07528705FD2C404A39988@KARMEX02.barco.com>
Content-Type: text/plain; charset="UTF-8"
Date: Fri, 09 Jul 2010 11:05:23 -0700
Message-ID: <1278698723.1638.8.camel@jd-laptop>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5
	tests=BAYES_20=-0.001
X-Spam-Level: 
X-Archive-Number: 201007/35
X-Sequence-Number: 35054

On Fri, 2010-07-09 at 15:31 +0200, Henry, Frank 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.

Name of file?
Version of PostgreSQL?

JD