Autovac cancellation is broken in v14 - Mailing list pgsql-hackers

From Jeff Janes
Subject Autovac cancellation is broken in v14
Date
Msg-id CAMkU=1wH2aUy+wDRDz+5RZALdcUnEofV1t9PzXS_gBJO9vZZ0Q@mail.gmail.com
Whole thread Raw
Responses Re: Autovac cancellation is broken in v14  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
If I create a large table with "CREATE TABLE ... AS SELECT ... from generate_series(1,3e7)" with no explicit transactions, then once it is done I wait for autovac to kick in, then when I try to build an index on that table (or drop the table) the autovac doesn't go away on its own.

Bisects down to:

commit 5788e258bb26495fab65ff3aa486268d1c50b123
Author: Andres Freund <andres@anarazel.de>
Date:   Wed Jul 15 15:35:07 2020 -0700

    snapshot scalability: Move PGXACT->vacuumFlags to ProcGlobal->vacuumFlags.

Which makes sense given the parts of the code this touches, although I don't understand exactly what the problem is.  The problem persists in HEAD (77c7267c37).

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach)
Next
From: Bruce Momjian
Date:
Subject: Re: "cert" + clientcert=verify-ca in pg_hba.conf?