On Wed, Nov 8, 2023 at 02:52:16PM -0500, Tom Lane wrote: > 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.
Thanks, TODO added. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.