Re: Postgres Databases growing without much reason

On Fri, 2003-02-14 at 05:58, Andreas Rust wrote:

How often are you running vacuum?

Tony Grant

> we are running Postgres 7.2.1 on a RH 7.2 System.
> Currently there is a (imho) rather small Database running on the Server
> and there are no other services eating up much of the CPU time. Only
> postgres acts pretty strange.
>
> The postgres 'data' directory grows far too fast. 90% of the queries to
> postgres are simple selects, and there are about 190 Tables which mostly
> are having ONLY 200-3000 rows. The 2 largest tables have 67000 and 132000
> rows.
>
> We had heavy performance problems and in the end I found, that the 'data'
> directory
> went up to 2 GB. This, by far, appeared too much for such a little dbase.
>
> 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.
>
> What is happening here ? Will upgrading to 7.2.4 or 7.3 help me out of this
> dilemma ?
> There are no views, rules or triggers put on this dbase so far and the
> Apache/PHP combo
> isnt using transactions either.
>
> Has anyone else found this behaviour so far ?
>
> Any input appreciated and urgently needed :)

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL