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 1wRtzS-002nBF-0W for pgsql-hackers@arkaria.postgresql.org; Tue, 26 May 2026 15:46:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wRtzQ-004vEC-0G for pgsql-hackers@arkaria.postgresql.org; Tue, 26 May 2026 15:46:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wRtzP-004vE2-2S for pgsql-hackers@lists.postgresql.org; Tue, 26 May 2026 15:46:44 +0000 Received: from mail-wr1-f53.google.com ([209.85.221.53]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wRtzO-00000001XUF-1OFf for pgsql-hackers@lists.postgresql.org; Tue, 26 May 2026 15:46:44 +0000 Received: by mail-wr1-f53.google.com with SMTP id ffacd0b85a97d-43d73422431so7619942f8f.2 for ; Tue, 26 May 2026 08:46:41 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779810400; cv=none; d=google.com; s=arc-20240605; b=DflHsxYLgajRysK1k+/bRCQUd+93xZR45qXysgAdb2o7gheDZJBSLpqQB/+4GzTrzT 1Y1r9GF1atuRvdL4YqK4Z4ec0p99vFApfpNVY9+9Z9L9+j0uo7fEEDW+oA13tzPd50m5 joMmMsruU01MhX8W5d/QKRW0L9gxYoLJ0X/A/6dzSi2RuywhIWm1UaVNOQw7qCyPBWHa WaP1QGA48BmTMmdFwOaIQdv0+f/v/DSvg+9Q8Jrm5GNACA0XfiZnu2uYBA4tJn2YAzfq ObdcrcMLABxvGPc5zsQQ0HCr8jkt3dhbDxmR/97j7IueHSmLeqHOxP1JhTaqgmoxUtp3 PVKw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version; bh=o72RH7l6k7zPqT060MaCLpyHI4K3ZIvF3PAvG0vP77o=; fh=ss9qmIPMmhQLsKxObLBPlWuFkAFLFhj7+hl1qAQfUOY=; b=kTQcVBCcwRvc6tyElRPWRzGQkMiYSVl4MtdC3V99pr9oJaLo9SfN9u4LxC06IDXHmq Ae0u4HaiF0k10zVK3KH8eDGDjXULRCKCX+GLoNoIxyXYbqjbof/gyGiEyRYgQU7js1U1 MNJBBtvOFYS4w8vlGNipUrc4/yngRtcYPPvv8IZVZgRjZ5kwybjhV/x07MQphrL/qbbH WqCq3XTHQEPNh90GzSaChziP9tg7rmOdBGp2S4wTdDzoDehx6jwHTaEgBHHXv0CBxD7B AbT12cdHqrgDjInxkleXDXxqNOU8a79TdJ0MIAeMe2KQJnZC43fE311uewghLJOFRFVo qmVA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779810400; x=1780415200; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=o72RH7l6k7zPqT060MaCLpyHI4K3ZIvF3PAvG0vP77o=; b=EZQuMgVYvFzrqk9Sa4DHmc9K+4CzuQExWS0/xup6EX1IqKGn8DKIMo2+yGGNCetNxm pRq/8mpEqesWwMCIlDsSS0ZhabyLDG1wsb2C3SUxqFju7ocBt3sdOd8YLweCZU5Bgu3B KTI4h5a4bE1IeGFrRKsMe/A5cufMQyPDrzQl5oOVkUJj12eeRI8n/6Ukbb4t/6uTEoma WojGTUe2lu7q1Vkpbj9qR3jwmfytP2uICjad/4+3At1w8IG/ibrycGgZqzWl1gshLG6e G9ZgpiJAA6NK4SBsP15fOYbBJ8Faxs1/PPnZbgh+twcwHiJF/iVsc26iRhdpO0JHSZ0v NOcg== X-Forwarded-Encrypted: i=1; AFNElJ8J/yHx1oaAp2iIKRzVwoec5X/54EVX8JiqXOmi8QQNzIgCLfRJWQLRkB8Zt6lH8e3kSJolVsdPLNNcfRiD@lists.postgresql.org X-Gm-Message-State: AOJu0YwxSIdRsnk6atwppAx49k+TQW+SaqwLPXKgaZ9uZhL/7wmN7vqH +usHCw53KotJqGlTzxgB/1YDcFCUJVBIYp4HiucymBn3E+3hwZwcNVXFHIuff+9QLWVWKxUj6Cu cYEb3NEtnoDKC5oVoc7UCfwPfP19Y91U= X-Gm-Gg: Acq92OGczggB6HWhAWVbNRFwILK0+RCqfwAU/TOffG3svZJ6JfsDpCel1VHOe8h14Dg 18bbaKllvM1e7duOhuYagNczpXTOsdnEGzl2foEfbZr6Tf00P+6T5v8QTXP131RPnmN+hfDyrDJ ANV8HyhzS3jVzLYx5UV3/yTY3rYk1tJrKSwbqDQNpAshIEShDBY/M/qQOj0F1F9QJbEyxwPKVWN 9bCwm2Gk+3ENKznOhWI0M7qNOBB3jrBBCgY4wREa8ErfqesnXSRIgfzT4cZfMEjGnJ177FBFfbn u6NbT52vcJ0c/HpyLyL/a+AWy+XB X-Received: by 2002:a5d:59c4:0:b0:45e:5c98:c8ed with SMTP id ffacd0b85a97d-45eb38af486mr28769637f8f.21.1779810400454; Tue, 26 May 2026 08:46:40 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Thom Brown Date: Tue, 26 May 2026 16:46:12 +0100 X-Gm-Features: AVHnY4KszIMS4NwCJnblQoCLB1TWVaxNKzLGktAm3gl-m6YNwsD2b-gvIhKtNUo Message-ID: Subject: Re: First draft of PG 19 release notes To: Bruce Momjian Cc: Chao Li , Peter Geoghegan , PostgreSQL-development , chong.peng@enmotech.com Content-Type: multipart/mixed; boundary="000000000000aff54f0652ba6654" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000aff54f0652ba6654 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, 26 May 2026 at 16:00, Bruce Momjian wrote: > > On Tue, May 26, 2026 at 01:25:15PM +0800, Chao Li wrote: > > 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 slotsy= nc_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) > > ``` > > Yes, very good point. I missed that detail when merging the commit > items. I fixed it as you suggested, patch attached. > > -- > Bruce Momjian https://momjian.us > EDB https://enterprisedb.com > > Do not let urgent matters crowd out time for investment in the future. Did a review and found a few issues. Attached fixes. Regards Thom --000000000000aff54f0652ba6654 Content-Type: text/x-patch; charset="US-ASCII"; name="release-19-fixes.patch" Content-Disposition: attachment; filename="release-19-fixes.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mpmt27m70 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWxlYXNlLTE5LnNnbWwgYi9kb2Mvc3JjL3NnbWwv cmVsZWFzZS0xOS5zZ21sCmluZGV4IGYwOTExYjg2MDA1Li45YWFlOTM0MjE1YSAxMDA2NDQKLS0t IGEvZG9jL3NyYy9zZ21sL3JlbGVhc2UtMTkuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVsZWFz ZS0xOS5zZ21sCkBAIC03Nyw3ICs3Nyw3IEBAIElzc3VlIGEgd2FybmluZyBhZnRlciBzdWNjZXNz ZnVsIE1ENSBwYXNzd29yZCBhdXRoZW50aWNhdGlvbiAoTmF0aGFuIEJvc3NhcnQpCiA8L3BhcmE+ CiAKIDxwYXJhPgotVGhlIHdhcm5pbmcgY2FuIGJlIGRpc2FibGVkIHZpYSBzZXJ2ZXIgdmFyaWFi bGUgbWQ1X3Bhc3N3b3JkX3dhcm5pbmdzLiAgTUQ1IHBhc3N3b3JkcyB3ZXJlIG1hcmtlZCBtYXJr ZWQgYXMgZGVwcmVjYXRlZCBpbiBQb3N0Z3JlcyAxOC4KK1RoZSB3YXJuaW5nIGNhbiBiZSBkaXNh YmxlZCB2aWEgc2VydmVyIHZhcmlhYmxlIG1kNV9wYXNzd29yZF93YXJuaW5ncy4gIE1ENSBwYXNz d29yZHMgd2VyZSBtYXJrZWQgYXMgZGVwcmVjYXRlZCBpbiBQb3N0Z3JlcyAxOC4KIDwvcGFyYT4K IDwvbGlzdGl0ZW0+CiAKQEAgLTE0NCw3ICsxNDQsNyBAQCBDaGFuZ2UgdGhlIGRlZmF1bHQgaW5k ZXggb3BjbGFzc2VzIGZvciBpbmV0IGFuZCBjaWRyIGRhdGEgdHlwZXMgZnJvbSBidHJlZV9naXN0 CiA8L3BhcmE+CiAKIDxwYXJhPgotVGhlIGJ0cmVlX2dpc3QgaW5ldC9jaWRyIG9wY2xhc3NlcyBh cmUgYnJva2VuIGJlY2F1c2UgdGhleSBjYW4gZXhjbHVkZSByb3dzIHRoYXQgc2hvdWxkIGJlIHJl dHVybmVkLiAgUGdfdXBncmFkZSB3aWxsIGZhaWwgdG8gdXBncmFkZSBpZiBidHJlZV9naXN0IGlu ZXQvY2lkciBpbmRleGVzIGV4aXN0IGluIHRoZSBvbGQKK1RoZSBidHJlZV9naXN0IGluZXQvY2lk ciBvcGNsYXNzZXMgYXJlIGJyb2tlbiBiZWNhdXNlIHRoZXkgY2FuIGV4Y2x1ZGUgcm93cyB0aGF0 IHNob3VsZCBiZSByZXR1cm5lZC4gIHBnX3VwZ3JhZGUgd2lsbCBmYWlsIHRvIHVwZ3JhZGUgaWYg YnRyZWVfZ2lzdCBpbmV0L2NpZHIgaW5kZXhlcyBleGlzdCBpbiB0aGUgb2xkCiBzZXJ2ZXIuCiA8 L3BhcmE+CiA8L2xpc3RpdGVtPgpAQCAtMzI4LDcgKzMyOCw3IEBAIEF1dGhvcjogUmljaGFyZCBH dW8gPHJndW9AcG9zdGdyZXNxbC5vcmc+CiAKIDxsaXN0aXRlbT4KIDxwYXJhPgotQWxsb3cgTk9U IElOcyB0byBiZSBjb252ZXJ0ZWQgdG8gbW9yZSBlZmZpY2llbnQgQU5USSBKT0lOcyB3aGVuIE5V TExzIGFyZSBub3QgcHJlc2VudCAoUmljaGFyZCBHdW8pCitBbGxvdyBOT1QgSU4gY2xhdXNlcyB0 byBiZSBjb252ZXJ0ZWQgdG8gbW9yZSBlZmZpY2llbnQgYW50aS1qb2lucyB3aGVuIE5VTExzIGFy ZSBub3QgcHJlc2VudCAoUmljaGFyZCBHdW8pCiA8dWxpbmsgdXJsPSImY29tbWl0X2Jhc2V1cmw7 MzgzZWIyMWViIj4mc2VjdDs8L3VsaW5rPgogPC9wYXJhPgogPC9saXN0aXRlbT4KQEAgLTcwMCw3 ICs3MDAsNyBAQCBBdXRob3I6IE5hdGhhbiBCb3NzYXJ0IDxuYXRoYW5AcG9zdGdyZXNxbC5vcmc+ CiAKIDxsaXN0aXRlbT4KIDxwYXJhPgotSW1wcm92ZSBDT1BZIEZST00gcGVyZm9ybWFuY2UgZm9y IHRleHQgYW5kIENTViBvdXRwdXQgdXNpbmcgU0lNRCBDUFUgaW5zdHJ1Y3Rpb25zIChOYXppciBC aWxhbCBZYXZ1eiwgU2hpbnlhIEthdG8pCitJbXByb3ZlIENPUFkgRlJPTSBwZXJmb3JtYW5jZSBm b3IgdGV4dCBhbmQgQ1NWIGlucHV0IHVzaW5nIFNJTUQgQ1BVIGluc3RydWN0aW9ucyAoTmF6aXIg QmlsYWwgWWF2dXosIFNoaW55YSBLYXRvKQogPHVsaW5rIHVybD0iJmNvbW1pdF9iYXNldXJsO2Uw YTNhM2ZkNSI+JnNlY3Q7PC91bGluaz4KIDwvcGFyYT4KIDwvbGlzdGl0ZW0+CkBAIC0xMjEwLDcg KzEyMTAsNyBAQCBBdXRob3I6IE5hdGhhbiBCb3NzYXJ0IDxuYXRoYW5AcG9zdGdyZXNxbC5vcmc+ CiAKIDxsaXN0aXRlbT4KIDxwYXJhPgotSXNzdWUgd2FybmluZ3Mgd2hlbiB0aGUgd3JhcGFyb3Vu ZCBvZiB4aWQgYW5kIG11bHRpLXhpZHMgaXMgbGVzcyB0aGVuIDEwMCBtaWxsaW9uIChOYXRoYW4g Qm9zc2FydCkKK0lzc3VlIHdhcm5pbmdzIHdoZW4gdGhlIHdyYXBhcm91bmQgb2YgeGlkIGFuZCBt dWx0aS14aWRzIGlzIGxlc3MgdGhhbiAxMDAgbWlsbGlvbiAoTmF0aGFuIEJvc3NhcnQpCiA8dWxp bmsgdXJsPSImY29tbWl0X2Jhc2V1cmw7NDhmMTFiZmEwIj4mc2VjdDs8L3VsaW5rPgogPC9wYXJh PgogCkBAIC0xNTg4LDcgKzE1ODgsNyBAQCBBZGQgc3Vic2NyaXB0aW9uIG9wdGlvbiBtYXhfcmV0 ZW50aW9uX2R1cmF0aW9uIHRvIGxpbWl0IHJldGFpbl9kZWFkX3R1cGxlcyByZXRlbgogPC9wYXJh PgogCiA8cGFyYT4KLVdoZW4gdGhlIGxpbWl0IGlzIHJlYWNoZWQsIGRlYWQgdHVwbGUgcmV0ZW50 aW9uIHVudGlsIG1hbnVhbGx5IHJlLWVuYWJsZWQgb3IgYSBuZXcgc3Vic2NyaXB0aW9uIGlzIGNy ZWF0ZWQuCitXaGVuIHRoZSBsaW1pdCBpcyByZWFjaGVkLCBkZWFkIHR1cGxlIHJldGVudGlvbiBp cyBkaXNhYmxlZCB1bnRpbCBtYW51YWxseSByZS1lbmFibGVkIG9yIGEgbmV3IHN1YnNjcmlwdGlv biBpcyBjcmVhdGVkLgogPC9wYXJhPgogPC9saXN0aXRlbT4KIAo= --000000000000aff54f0652ba6654--