Re: Second attempt, roll your own autovacuum

Csaba Nagy wrote:
>
>> - One might have *two* consumers, one that will only process small
>>   tables, so that those little, frequently updated tables can get
>>   handled quickly, and another consumer that does larger tables.
>>   Or perhaps that knows that it's fine, between 04:00 and 09:00 UTC,
>>   to have 6 consumers, and blow through a lot of larger tables
>>   simultaneously.
>
> So one of the 2 might be enough. I guess time-based
> exclusion/permissions are not that easy to implement, and also not easy
> to set up properly... so what could work well is:

Alternatively, perhaps a threshold so that a table is only considered
for vacuum if:
   (table-size * overall-activity-in-last-hour) < threshold
Ideally you'd define your units appropriately so that you could just
define threshold in postgresql.conf as 30% (of peak activity in last 100
hours say).

--
   Richard Huxton
   Archonet Ltd