Re: Postgres Databases growing without much reason
От | Tony Grant |
---|---|
Тема | Re: Postgres Databases growing without much reason |
Дата | |
Msg-id | 1045244334.1623.34.camel@localhost обсуждение исходный текст |
Ответ на | Postgres Databases growing without much reason (Andreas Rust <rust@webnova.de>) |
Ответы |
Re: Postgres Databases growing without much reason
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: