On Tue, Feb 15, 2022 at 9:28 AM Peter Geoghegan <p...@bowt.ie> wrote: > On Mon, Feb 14, 2022 at 10:04 PM John Naylor > <john.nay...@enterprisedb.com> wrote: > > Well, the point of inventing this new vacuum mode was because I > > thought that upon reaching xidStopLimit, we couldn't issue commands, > > period, under the postmaster. If it was easier to get a test instance > > to xidStopLimit, I certainly would have discovered this sooner. > > I did notice from my own testing of the failsafe (by artificially > inducing wraparound failure using an XID burning C function) that > autovacuum seemed to totally correct the problem, even when the system > had already crossed xidStopLimit - it came back on its own. I wasn't > completely sure of how robust this effect was, though.
It seemed worth noting this in comments above should_attempt_truncation(). Pushed a commit to do that just now. Thanks -- Peter Geoghegan
