Re: [GENERAL] Vacuum process idle but hogging memory 8.2.4

2007-09-03 Thread Tom Lane
Henrik <[EMAIL PROTECTED]> writes: > I'm already started to redesign the database to avoid the hugh number > of rows in this big table but I'm still curious why autovacuum hogs > over 200MB when it is not running? On what do you base that assertion? > Is it the shared_buffers? Well, 128M in

[GENERAL] Vacuum process idle but hogging memory 8.2.4

2007-09-03 Thread Henrik
Hello list, System is running linux kernel 2.6.18 with postgres 8.2.4 and 1GB ram. I'm having a 50GB database with the biggest table taking about 30 GB and has about 200 million rows. I'm already started to redesign the database to avoid the hugh number of rows in this big table but I'm st