Thread

  1. Re: First draft of PG 19 release notes

    Chao Li <li.evan.chao@gmail.com> — 2026-05-26T05:25:15Z

    
    > On May 16, 2026, at 01:27, Bruce Momjian <bruce@momjian.us> wrote:
    > 
    > On Fri, May 15, 2026 at 12:31:59PM -0400, Peter Geoghegan wrote:
    >> On Tue, Apr 14, 2026 at 9:19 PM Bruce Momjian <bruce@momjian.us> wrote:
    >>> I have completed the first draft of the PG 19 release notes:
    >>> 
    >>>        https://www.postgresql.org/docs/devel/release-19.html
    >> 
    >> I do not think that this item merits mention in the release notes:
    >> 
    >> "Add fake LSN support to hash index AM (Peter Geoghegan)"
    >> 
    >> It offers no user-visible benefit. It's just preparation for index
    >> prefetching, which didn't make it into Postgres 19.
    > 
    > Ah, I see your point, and the commit message was clear:
    > 
    >    This commit is similar to commit 8a879119, which taught nbtree to
    >    use fake LSNs to improve its dropPin behavior.  However, unlike that
    >    commit, this is not an independently useful enhancement, since hash
    >    doesn't implement anything like nbtree's dropPin behavior (not yet).
    > 
    > Item removed.
    > 
    > -- 
    >  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
    >  EDB                                      https://enterprisedb.com
    > 
    >  Do not let urgent matters crowd out time for investment in the future.
    > 
    > 
    
    Chong Peng, whom I added to CC, reported this release note issue to me, so I’m just forwarding the message:
    
    ```
    <listitem>
    <para>
    Add slot synchronization skip information to pg_stat_replication_slots (Shlok Kyal)
    <ulink url="&commit_baseurl;76b78721c">&sect;</ulink>
    <ulink url="&commit_baseurl;e68b6adad">&sect;</ulink>
    <ulink url="&commit_baseurl;5db6a344a">&sect;</ulink>
    </para>
    
    <para>
    The new columns are slotsync_skip_count, slotsync_last_skip, and slotsync_skip_reason.
    </para>
    </listitem>
    ```
    
    The feature description is inaccurate: slotsync_skip_count and slotsync_last_skip belong to pg_stat_replication_slots, while slotsync_skip_reason belongs to pg_replication_slots. Maybe it could be reworded as:
    ```
    Add slot synchronization skip information to pg_stat_replication_slots and pg_replication_slots (Shlok Kyal)
    ```
    
    Best regards,
    --
    Chao Li (Evan)
    HighGo Software Co., Ltd.
    https://www.highgo.com/