Stephen Frost <sfr...@snowman.net> writes: > I agree that 'constantly' wouldn't be great, but with some periodicity > that's more frequent than 'not until a few hours later when we finally > finish vacuuming this relation' would be nice. At least with autovauum > we may be periodically sleeping anyway so it doesn't seem like polling > at that point would really be terrible, though it'd be nice to check > every once in a while even if we aren't sleeping.
Maybe put a check into vacuum_delay_point, and poll the pipe when we're about to sleep anyway? That wouldn't fix anything except autovacuum, but if you're right that that's a primary pain point then it'd help. regards, tom lane