On Wed, Sep 17, 2025 at 7:22 PM Andres Freund <andres@anarazel.de> wrote:
> I continue to find this argument extremely unconvincing. It's very common for
> autovacuum to be continuously be busy with the one large table that has a
> bunch of indexes. Vacuuming that one table is what prevents the freeze horizon
> to move forward / prevents getting out of anti-wraparound territory in time.
The problem is that we're not smart enough to know whether this is the
case or not. It's also fairly common for tables to get starved because
all of the autovacuum workers are busy. Until we get a real scheduling
system for autovacuum, I don't see this area improving very much.
--
Robert Haas
EDB: http://www.enterprisedb.com
