model-writtenrun 8191 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Jeff Janes reported that autovacuum failed to yield when CREATE INDEX or DROP TABLE needed access, and bisected the regression to the vacuumFlags relocation in #1.
- Jeff Janes identified that ProcSleep() checked the waiting process's vacuum flags instead of the blocking autovacuum worker's flags, posted a one-line correction, and asked about regression testing in #2.
- Andres Freund explained that testing would require coordinating autovacuum startup and blocking its progress, likely through a potentially fragile TAP test, in #3.
- Andres Freund committed Jeff's patch unchanged as 5871f09c98, leaving out a regression test because no reliable approach had been established.
- Andres Freund confirmed the fix was pushed and proposed discussing interruptible manual VACUUM operations in a separate thread as a possible testing aid in #4; the fix was complete, while testing remained unresolved.