Re: Postgres Databases growing without much reason

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Andreas Rust <rust(at)webnova(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Databases growing without much reason
Date: 2003-02-14 13:03:04
Message-ID: 20030214130303.GA20307@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jco 2003-02-14 13:09:09 Re: How can I parse a Postgresql array result in php?
Previous Message Pablo Varasa 2003-02-14 13:02:27 Re: db "hot switch"