Bruce Momjian <br...@momjian.us> writes: > On Sat, Nov 23, 2019 at 12:10:56PM -0500, Tom Lane wrote: >>> It suddenly strikes me to worry that we have an XID wraparound hazard >>> for entries in the notify queue.
> Is this still an open issue? Should it be a TODO item? I don't think anyone's done anything about it, so yeah. Realistically, if you've got NOTIFY messages that are going unread for long enough to risk XID wraparound, your app is broken. So maybe it'd be sufficient to discard messages that are old enough to approach the wrap horizon. But still that's code that doesn't exist. regards, tom lane