Re: another autovacuum scheduling thread - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: another autovacuum scheduling thread
Date
Msg-id abAzhNqs5F8sJDdm@nathan
Whole thread Raw
In response to Re: another autovacuum scheduling thread  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: another autovacuum scheduling thread
List pgsql-hackers
On Thu, Mar 05, 2026 at 11:03:50AM -0600, Nathan Bossart wrote:
> My apologies for getting distracted from this work.  It might be a v20 item
> at this point.  I haven't addressed any feedback since the v8 patch, but I
> did some testing.

Here's an updated patch with new GUCs that control how much each component
contributes to the autovacuum score for a table.  They default to 1.0, but
can be set anywhere from 0.0 to 1.0 (inclusive).  In theory, setting all of
them to 0.0 should restore the original pg_class order prioritization that
we have today.  I haven't added corresponding reloptions for these GUCs, as
I'm not convinced we need them, but I can add them if folks think they
would be useful.

-- 
nathan

Attachment

pgsql-hackers by date:

Previous
From: Ilia Evdokimov
Date:
Subject: Re: Hash-based MCV matching for large IN-lists
Next
From: Robert Haas
Date:
Subject: Re: Change initdb default to the builtin collation provider