Re: Fix safe_wal_size for slots without restart_lsn - Mailing list pgsql-hackers

From Xuneng Zhou
Subject Re: Fix safe_wal_size for slots without restart_lsn
Date
Msg-id CABPTF7WVLrbOydpEMiS0rTdp_ZhEJD=QJ=X1Z5FA6ph8ejmW4A@mail.gmail.com
Whole thread
In response to Re: Fix safe_wal_size for slots without restart_lsn  (Xuneng Zhou <xunengzhou@gmail.com>)
List pgsql-hackers
On Thu, May 28, 2026 at 9:01 AM Xuneng Zhou <xunengzhou@gmail.com> wrote:
>
> On Wed, May 27, 2026 at 6:55 PM Xuneng Zhou <xunengzhou@gmail.com> wrote:
> >
> > Hi,
> >
> > Currently, pg_replication_slots can report a non-null safe_wal_size
> > for a replication slot that has never reserved WAL, if
> > max_slot_wal_keep_size is finite.
> >
> > Such a slot has restart_lsn = NULL and wal_status = NULL. safe_wal_size is
> > derived from restart_lsn, so it's not meaningful in this state. The
> > current code handles WALAVAIL_REMOVED but not WALAVAIL_INVALID_LSN
> > before computing safe_wal_size, leading arithmetic on InvalidXLogRecPtr.
> >
> > Fix this by returning NULL for safe_wal_size when WAL availability is
> > WALAVAIL_INVALID_LSN.
> >
>
> Fixed the indentation issue in v1 and updated the comment and doc. Not
> sure this small issue warrants an additional test, still added one in
> case someone wants it.

Improved the readability of the new test.

--
Regards,
Xuneng Zhou
HighGo Software Co., Ltd.

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: Tomas Vondra
Date:
Subject: Re: Is there value in having optimizer stats for joins/foreignkeys?