Re: [GENERAL] Database growing. Need autovacuum help.

2008-06-05 Thread Henrik
3 jun 2008 kl. 16.06 skrev Scott Marlowe: On Tue, Jun 3, 2008 at 7:41 AM, Henrik [EMAIL PROTECTED] wrote: To be able to handle versions we always insert new folders even though nothing has changed but it seemd like the best way to do it. E.g First run: tbl_file 500k new files.

[GENERAL] Database growing. Need autovacuum help.

2008-06-03 Thread Henrik
Hi List, We are running a couple of 8.3.1 servers and the are growing a lot. I have the standard autovacuum settings from the 8.3.1 installation and we are inserting about 2-3 million rows every night and cleaning out just as many every day. The database size rose to 80GB but after a

Re: [GENERAL] Database growing. Need autovacuum help.

2008-06-03 Thread Bill Moran
In response to Henrik [EMAIL PROTECTED]: We are running a couple of 8.3.1 servers and the are growing a lot. I have the standard autovacuum settings from the 8.3.1 installation and we are inserting about 2-3 million rows every night and cleaning out just as many every day. Is this a

Re: [GENERAL] Database growing. Need autovacuum help.

2008-06-03 Thread Scott Marlowe
On Tue, Jun 3, 2008 at 7:41 AM, Henrik [EMAIL PROTECTED] wrote: To be able to handle versions we always insert new folders even though nothing has changed but it seemd like the best way to do it. E.g First run: tbl_file 500k new files. tbl_folder 50k new rows.

Re: [GENERAL] Database growing. Need autovacuum help.

2008-06-03 Thread Henrik
3 jun 2008 kl. 15.23 skrev Bill Moran: In response to Henrik [EMAIL PROTECTED]: We are running a couple of 8.3.1 servers and the are growing a lot. I have the standard autovacuum settings from the 8.3.1 installation and we are inserting about 2-3 million rows every night and cleaning out