Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wRkId-002eLb-1B for pgsql-hackers@arkaria.postgresql.org; Tue, 26 May 2026 05:25:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wRkIb-002whn-1K for pgsql-hackers@arkaria.postgresql.org; Tue, 26 May 2026 05:25:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wRkIb-002whe-0O for pgsql-hackers@lists.postgresql.org; Tue, 26 May 2026 05:25:54 +0000 Received: from mail-dy1-x1335.google.com ([2607:f8b0:4864:20::1335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wRkIa-00000000o0v-1WIo for pgsql-hackers@lists.postgresql.org; Tue, 26 May 2026 05:25:53 +0000 Received: by mail-dy1-x1335.google.com with SMTP id 5a478bee46e88-304545f5206so4943251eec.0 for ; Mon, 25 May 2026 22:25:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779773151; x=1780377951; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=KgDMIUC3oXP0AjxMzPnN5WHctcVP8DAeJ40tk1zAM6M=; b=QzqyRZZyi89jFjW/SHd2Pp7/AezHO1qah+L+j1hgd3v0LOy6D44S9kfU3lTeMimTUn SnzawhhdFGU6yL2CEauB6yi65VDMxrj+SeDCJQH+BCUbWKSbGrDRqKYAzrc5POAlo6aT tTA2Bl1fRoIV4phAeuXu24EF2bXfrxyhT8nwlyShA8rGsdO+Hiyd3BByN6oawjqtaqJF youI4z2ciM8QSCKYeuWaQ8efyRcfxD/n+FLbLj8nqP1/37uMwL2K2pS1R0nd8DuY8dkN xGdeFLkdOc7rRhQSSrLO9Veg2XiUkbL7Y/gIrm5fBZn/lIUlmy2Rtdcx9yb4hC3qP9lp UKeQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779773151; x=1780377951; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=KgDMIUC3oXP0AjxMzPnN5WHctcVP8DAeJ40tk1zAM6M=; b=E5O/7Am+APqySS20KGJOx59e1BlFl82R83WwKA8ldQgmshDJvcQIkiRUtHqNiRadEO pEeeP7aTWIio69yPh91SL9/tP4ytmf4PaTRZpgavpT/9K1aV2zaPRwyt7NlJFbSCxbeJ iBtNlIbTw78kGS+uv5d+uq20iekw/OdKCrrYcJwTlKTi5ZXPtfFOzlvpUXd9vkCglIxi rLXDBDh27PQZ8A4qSQpeFjWHEvaIuJsLw42JdvFWVzPDnXotNsjG4AehnvByDiGB4mTn YTwdfVhx6+41809d3X0WzNzeveLf5XoPbXw0lkBlWFVLHyN0zlcDCA+mhDyseHPFqqfn niTA== X-Forwarded-Encrypted: i=1; AFNElJ9+T2BH6HPUijxSeXUMhAaMugb3+Y9NdizPl5eNjkXJzjokn7Mt/jXEbRGJ0e+zo0UZAIMwfpOglSTIznzB@lists.postgresql.org X-Gm-Message-State: AOJu0YyqDwqbebW2H1XzQRheocAxPesXwGSeF+1jnqUNX77u8mwh6s7y 1To8KanuMItxHJUGVDNQeP9tOKQjyxlOhkrOeSmrGkvFArCB6ZhmpgDQx0k/c6vM X-Gm-Gg: Acq92OGWWaVXmvToyphCyB3SfGY/Tvp5YSeUxWy877g5+w3d5dO4XOyjX7aOSC2STl5 6CYQDel9Y4hO/3xXf0V09DmB9P0K4xbNGD/mkYOolzkB5U+fPUVvzs3DwpSxT+gYzEuYI6AjE5/ IF4/KPmSJVNVjwHaA4l6YaN0HQtWpEAojR20oM98dvktILBJFlrfxoKdyy2MxiExHmqNMQa0TKs rfrAXEIifyp7Q0H1o3v0xrtVcE/0gArm1u9MGzwoTSvIFd8kyF5n87trKMFLJiKWn7I4JyZM4De pxRanYi/p9kzgEKQJzyEQ6s72c/ZBaCmS053+sZTSXFb+RfavEekH9k4XjaGwq1WOI6/hdBReDt ujlyKnxSSvzz1zXvZiwlArDKoH2/yKkiTsBKNRHsIeShLNdW/Za/PB415Z2x4d4vf5HNiR95JHB J2sP+/WgpdPeEMXj9LYa5ppv5zDpvw2A== X-Received: by 2002:a05:7300:a903:b0:2e6:e916:70ff with SMTP id 5a478bee46e88-3044912e569mr7097496eec.28.1779773151092; Mon, 25 May 2026 22:25:51 -0700 (PDT) Received: from smtpclient.apple ([64.32.14.230]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-3045223103bsm9286197eec.16.2026.05.25.22.25.49 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 25 May 2026 22:25:50 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\)) Subject: Re: First draft of PG 19 release notes From: Chao Li In-Reply-To: Date: Tue, 26 May 2026 13:25:15 +0800 Cc: Peter Geoghegan , PostgreSQL-development , chong.peng@enmotech.com Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Bruce Momjian X-Mailer: Apple Mail (2.3864.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On May 16, 2026, at 01:27, Bruce Momjian wrote: >=20 > On Fri, May 15, 2026 at 12:31:59PM -0400, Peter Geoghegan wrote: >> On Tue, Apr 14, 2026 at 9:19=E2=80=AFPM Bruce Momjian = wrote: >>> I have completed the first draft of the PG 19 release notes: >>>=20 >>> https://www.postgresql.org/docs/devel/release-19.html >>=20 >> I do not think that this item merits mention in the release notes: >>=20 >> "Add fake LSN support to hash index AM (Peter Geoghegan)" >>=20 >> It offers no user-visible benefit. It's just preparation for index >> prefetching, which didn't make it into Postgres 19. >=20 > Ah, I see your point, and the commit message was clear: >=20 > 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). >=20 > Item removed. >=20 > --=20 > Bruce Momjian https://momjian.us > EDB https://enterprisedb.com >=20 > Do not let urgent matters crowd out time for investment in the = future. >=20 >=20 Chong Peng, whom I added to CC, reported this release note issue to me, = so I=E2=80=99m just forwarding the message: ``` Add slot synchronization skip information to pg_stat_replication_slots = (Shlok Kyal) § § § The new columns are slotsync_skip_count, slotsync_last_skip, and = slotsync_skip_reason. ``` 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/