Re: [GENERAL] VACUUM process running for a long time

2010-04-15 Thread Jan Krcmar
hi 2010/4/14 Adrian von Bidder : >  -> vacuum can run concurrently to other stuff, so it's not necessary to > wait before it finishes. >  -> in most cases, autovacuum should do the Right Thing(tm) atomatically, so > you should not need to call vacuum manually. > > This is with a recent pg version.

Re: [GENERAL] VACUUM process running for a long time

2010-04-14 Thread Jan Krcmar
2010/4/14 John R Pierce : > Jan Krcmar wrote: >> >> hi >> >> i've got the database (about 300G) and it's still growing. >> >> i am inserting new data (about 2G/day) into the database (there is >> only one table there) and i'm also

[GENERAL] VACUUM process running for a long time

2010-04-14 Thread Jan Krcmar
hi i've got the database (about 300G) and it's still growing. i am inserting new data (about 2G/day) into the database (there is only one table there) and i'm also deleting about 2G/day (data older than month). the documentation says, one should run VACUUM if there are many changes in the databa