Re: XID-wraparound hazards in LISTEN/NOTIFY

On Wed, Nov  8, 2023 at 02:52:16PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce@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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.