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
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
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
