Re: autovacuum strategy / parameters - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: autovacuum strategy / parameters
Date
Msg-id r2ydcc563d11005010908u4e08ed56q46932333310e260b@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum strategy / parameters  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
On Wed, Apr 28, 2010 at 8:20 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Rick, 22.04.2010 22:42:
>>
>> So, in a large table, the scale_factor is the dominant term. In a
>> small table, the threshold is the dominant term. But both are taken into
>> account.
>>
>> The default values are set for small tables; it is not being run for
>> large tables.
>
> With 8.4 you can adjust the autovacuum settings per table...

You can as well with 8.3, but it's not made by alter table but by
pg_autovacuum table entries.

pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Optimization idea
Next
From: Scott Marlowe
Date:
Subject: Re: autovacuum strategy / parameters