Re: [GENERAL] autovacuum

2008-10-31 Thread Noah Freire
On Wed, Oct 29, 2008 at 4:46 PM, Matthew T. O'Connor <[EMAIL PROTECTED]>wrote: > Noah Freire wrote: > >> <2008-10-29 11:09:03.453 PDT>DEBUG: 0: accounts: vac: 16697969 >> (threshold 650), anl: 16697969 (threshold 12048) >> <2008-10-29

Re: [GENERAL] autovacuum

2008-10-31 Thread Noah Freire
On Thu, Oct 30, 2008 at 8:53 PM, Matthew T. O'Connor <[EMAIL PROTECTED]>wrote: > Noah Freire wrote: > >> On Wed, Oct 29, 2008 at 4:46 PM, Matthew T. O'Connor <[EMAIL >> PROTECTED]> [EMAIL PROTECTED]>> wrote: >>Is the table being excluded

[GENERAL] autovacuum

2008-10-29 Thread Noah Freire
Hello, I have a table (accounts) with 600,000,000 rows. A heavy high-concurrent workload that makes mostly updates on this table generates a lot of dead tuples in its run, which is expected due to MVCC. The problem is that even though autovacuum is enabled, the autovacuum worker does not vacuum th