Re: [HACKERS] autovacuum: I need some explanation

2008-10-29 Thread Noah Freire
Hi Alvaro, On Wed, Oct 29, 2008 at 3:46 PM, Alvaro Herrera <[EMAIL PROTECTED]>wrote: > Noah Freire escribió: > > > please check the first log message: the vacuum threshold is 6,000,050 > rows > > and the number of dead tuples is 16,697,969. Even though the number of

[HACKERS] autovacuum: I need some explanation

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