Re: Postgres Databases growing without much reason - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Postgres Databases growing without much reason
Date
Msg-id 20030214130303.GA20307@svana.org
Whole thread Raw
In response to Postgres Databases growing without much reason  (Andreas Rust <rust@webnova.de>)
Responses Re: Postgres Databases growing without much reason  (Andreas Rust <rust@webnova.de>)
List pgsql-general
On Fri, Feb 14, 2003 at 11:58:00AM +0100, Andreas Rust wrote:
> I completely dumped the dbase, dropped and restored it and instead of 2 GB
> it was
> only using 150 MB then. Now, after having this running for about 2 Weeks
> constantly,
> the performance is falling down again and the database grew up to 550 MB
> again, although
> there was not much inserted into the dbase-tables.

Can you find which files in the data directory are growing? They're numbered
by oid, which you can lookup in pg_class.

Hope this helps,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

Attachment

pgsql-general by date:

Previous
From: Pablo Varasa
Date:
Subject: Re: db "hot switch"
Next
From: jco@cornelius-olsen.dk
Date:
Subject: Re: How can I parse a Postgresql array result in php?