On 2020-Oct-29, Stephen Frost wrote: > I do think it'd be good to find a way to check every once in a while > even when we aren't going to delay though. Not sure what the best > answer there is.
Maybe instead of thinking specifically in terms of vacuum, we could count buffer accesses (read from kernel) and check the latch once every 1000th such, or something like that. Then a very long query doesn't have to wait until it's run to completion. The cost is one integer addition per syscall, which should be bearable. (This doesn't help with a query that's running arbitrarily outside of Postgres, or doing something that doesn't access disk -- but it'd help with a majority of problem cases.)
