Autovac cancellation is broken in v14
Jeff Janes <jeff.janes@gmail.com>
From: Jeff Janes <jeff.janes@gmail.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>,
Andres Freund <andres@anarazel.de>, Robert Haas <robertmhaas@gmail.com>, Thomas Munro <thomas.munro@gmail.com>, David Rowley <dgrowleyml@gmail.com>
Date: 2020-08-27T19:10:47Z
Lists: 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
Commits
-
Fix autovacuum cancellation.
- 5871f09c9858 14.0 landed
-
snapshot scalability: Move PGXACT->vacuumFlags to ProcGlobal->vacuumFlags.
- 5788e258bb26 14.0 cited