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 1vyNgd-0004DU-1v for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 05:25:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyNgb-002dzW-2l for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Mar 2026 05:25:18 +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 1vyNgb-002dzO-1P for pgsql-hackers@lists.postgresql.org; Fri, 06 Mar 2026 05:25:18 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyNgZ-00000000ii9-3RZ7 for pgsql-hackers@lists.postgresql.org; Fri, 06 Mar 2026 05:25:16 +0000 Received: by mail-pl1-x633.google.com with SMTP id d9443c01a7336-2ae45a4cc54so35784535ad.0 for ; Thu, 05 Mar 2026 21:25:15 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772774715; cv=none; d=google.com; s=arc-20240605; b=lIhrEKeaakYcfvUjKOzmvmpk6Mh8No8Cp+soegvbtSvGmmTqBxmn0lNjY5qJkQOw7O XbemkjTOhV5b9dxEqRGxovkGpsq+VH2kknylma5A8QaxILAcsyfv43sTvAhh9Ikte9Qd 41YRrm9ST9gRwVMLkKEaB8XVex3zWf05AYrt9r0dCAKUEwzK0TMHR40l86ePHX+w4Hms EZihOBCE1K6K8qfaNy7j9ZOi+SPju+2/MHzMEMK5ft+h6Z+A7/s8U6dAxpOZlvSLjuGo SksaMc3j0FkJGPm6QzRtkDpmBVTcRL3K+gfsAFoUdxTsqNBnL+EU9Kqn8t3IT8j/TXYq 3Hug== 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:dkim-signature; bh=542ZcmRFruDXRvxEeJyjX0WmZ1ICvgdMuBmUiXrq8cg=; fh=2MlMJXUgx4fVBihf70Ew5Ikg7gFXKVgL7cUqTYiUEhk=; b=apvFfB4dUjdUFZkwF2E7AQEIoEZQjfrEjyTMhYQMwB1at4zP4ZCMz9RTqbcPj1TCP8 4a/6H2iM7/r9ZpBAEVFoSvyccWD/QaXNNRu0A4Bihd2C43/0m6f2/SjrxyA4uPAhqNW4 na9YPYPp7Egu/Wz1iY7iNeFmGMvSXNG9b2Nk/k40q72v1OdlXBf+lWZhbEDvSWHraZNL I+XLzroQPWg9VUKSLBxCwzN0KX+mn7B7f2ra1dqB4uft8hO+ZL4lzzi4lolzQ0XOQNVu rrZ5yugd01zcOVc2xqMLmpsAAzIxkMVycDbIjZzu1BszMCK4fhuEFGsRhzuqpYEgwTIq 9niw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772774715; x=1773379515; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=542ZcmRFruDXRvxEeJyjX0WmZ1ICvgdMuBmUiXrq8cg=; b=ZNNRDsWnkwb81FTKs0aE0i6VgpAgjNs04vk5S2taMtGFhoRlJa680tXbY93O8YSDbz Lb87qoWEifkPfBRNOVKc4LZP4IsTbHFGzyjbO9g8iMNJxHmCDmqQ9Cf32AFxPNq5CUiw EkpD9R+Wcx60nMnxyPq3DJvrrmBfgqarVvbZRvebw0Ksci13FE4lyYdqB8vDAJ2yh3cY a0CUdbGDjTpLDzUua526JUHGb/0x5Z0enr0cg2sncUYCAtVyKhtHXyGNyyS+NGy2gFWj WYDWh8/Eae860yhcwHqhPFll1hraPWB+/mZ7vKW0yUYfCfdn+2+/QiqVBf4ZqqNx6+jj wN1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772774715; x=1773379515; 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=542ZcmRFruDXRvxEeJyjX0WmZ1ICvgdMuBmUiXrq8cg=; b=T6/uxFcKuDy9Qebl0wkX2z0wuKFPHGmxhsxK650gbAgQX1ZW/gROvbOwJO9U9eQ20F CU/sJOzKIieOU6q6mUXV+9Ndc6TmgXjswwWl8pPlnD55UIYNOOc7Ruoltfd7tYaVOWV5 VKBg8YWq5oZLFHgqIG3yjBfwMy8nbF3AuoY9JKronFFc0sGhjETdzPwFuD6tIw3hiF7E Z4IyUthvNdMbnZhVzLieRqrMRQ8dC2xXoHgdzKdcHHNPXQVPKhuhdujUJrgS+d8NAPaU mhiC8/rNF0aMrvA4beKrKkijc8Ob+SITJCG3xeLdQuVzV7ghsoFvwekGTFiqLbIAN338 4SOQ== X-Forwarded-Encrypted: i=1; AJvYcCX/C6XlgHuue7giC1xVpKNlyMVVpel2ssBgNUd2isUfecs5Rj5JtMftHyzqDp4Qs/mw+jKUozm9cAFziHiK@lists.postgresql.org X-Gm-Message-State: AOJu0YxSLu4Xw0J3XxASP9bBm9hjceE1pHOoXZjDnee0GlINHkN3SLXs DYwtVVq2kf9ajIqoU7wF3aBaQDRRgzMoylamB0FN937HPR2abCA3xbMqvJHmYYTYpu9Km2nDScF /zKTVqFad3HsrQasFBreoiWOjyJCdi+o= X-Gm-Gg: ATEYQzziCR8GU4MRfsZxA9w+NSHYLtoYn35wSCd/uLqf4r6KG9GG1SuKHav/J3Eivho OQqT2RBYywK/Eb4vxGrUBckaEX7nY7SdFvSD/ZCfgILGsCf/2w7s2POEm0cc+14vAxDwh7dPrdr fOifNCjWyzO8Wl3vYHxcp28mpqrO2bhOJpJ5ZoA+GbQN1WKnlFFBdIi5GId3qppPvhNilrOWrhi IVRwli34kq5DoiK4Tyt/WGs4GRA5pNHqJp4m2oQR+rwuT4Xk7WFRKJlowKnVhdTFt2ZfhMkc6MH 2OXcF0mS2CT9/KXN2z2lRdl6EOQUjsyquzSweem9+I2fY/kgfpHIiw== X-Received: by 2002:a17:903:1786:b0:2ae:47af:3b29 with SMTP id d9443c01a7336-2ae82579771mr9939365ad.57.1772774714793; Thu, 05 Mar 2026 21:25:14 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Fri, 6 Mar 2026 10:55:02 +0530 X-Gm-Features: AaiRm51WPd4jQbrE8ig-ij9VOtQhRlkqaORv9O2DM1-7iix8-XEfyYyXLcOlN98 Message-ID: Subject: Re: [PATCH] Support automatic sequence replication To: "Zhijie Hou (Fujitsu)" Cc: Amit Kapila , Ajin Cherian , "Hayato Kuroda (Fujitsu)" , Ashutosh Sharma , PostgreSQL Hackers , shveta malik Content-Type: multipart/mixed; boundary="000000000000247c7c064c5447b8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000247c7c064c5447b8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Mar 5, 2026 at 5:04=E2=80=AFPM Zhijie Hou (Fujitsu) wrote: > > > Thanks for catching this, I changed it to check the increment before repo= rting warning. > Thanks! I have changed comments atop sequencesync.c to get rid of old implementation details (worker dependency upon INIT state) and rephrased a little bit. Please take it if you find it okay. Attaching patch as txt file. It is a top-up for 0001. thanks Shveta --000000000000247c7c064c5447b8 Content-Type: text/plain; charset="US-ASCII"; name="0001-header-comment-improvement.patch.txt" Content-Disposition: attachment; filename="0001-header-comment-improvement.patch.txt" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmeg6urz0 RnJvbSAyMmE1NzViYzJhYjQzNzk1YzcyZjIyNDA0ODVjMTg5MjYyNjcyMDM1IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBTaHZldGEgTWFsaWsgPHNodmV0YS5tYWxpa0BnbWFpbC5jb20+ CkRhdGU6IEZyaSwgNiBNYXIgMjAyNiAxMDo0NTowMSArMDUzMApTdWJqZWN0OiBbUEFUQ0hdIGhl YWRlciBjb21tZW50IGltcHJvdmVtZW50CgotLS0KIC4uLi9yZXBsaWNhdGlvbi9sb2dpY2FsL3Nl cXVlbmNlc3luYy5jICAgICAgICB8IDQ5ICsrKysrKysrKy0tLS0tLS0tLS0KIDEgZmlsZSBjaGFu Z2VkLCAyMiBpbnNlcnRpb25zKCspLCAyNyBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9zcmMv YmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3NlcXVlbmNlc3luYy5jIGIvc3JjL2JhY2tlbmQv cmVwbGljYXRpb24vbG9naWNhbC9zZXF1ZW5jZXN5bmMuYwppbmRleCBjZGU5ZWFiYTQ3NC4uYTgw ZDVlNWIzMzUgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvc2Vx dWVuY2VzeW5jLmMKKysrIGIvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9zZXF1ZW5j ZXN5bmMuYwpAQCAtMTksMzcgKzE5LDMyIEBACiAgKiBDUkVBVEUgU1VCU0NSSVBUSU9OCiAgKiBB TFRFUiBTVUJTQ1JJUFRJT04gLi4uIFJFRlJFU0ggUFVCTElDQVRJT04KICAqCi0gKiBUaGUgYXBw bHkgd29ya2VyIHBlcmlvZGljYWxseSBzY2FucyBwZ19zdWJzY3JpcHRpb25fcmVsIGZvciBzZXF1 ZW5jZXMgaW4KLSAqIElOSVQgc3RhdGUuIFdoZW4gc3VjaCBzZXF1ZW5jZXMgYXJlIGZvdW5kLCBp dCBzcGF3bnMgYSBzZXF1ZW5jZXN5bmMgd29ya2VyCi0gKiB0byBoYW5kbGUgc3luY2hyb25pemF0 aW9uLgotICoKLSAqIEEgc2luZ2xlIHNlcXVlbmNlc3luYyB3b3JrZXIgaXMgcmVzcG9uc2libGUg Zm9yIHN5bmNocm9uaXppbmcgYWxsIHNlcXVlbmNlcy4KLSAqIEl0IGJlZ2lucyBieSByZXRyaWV2 aW5nIHRoZSBsaXN0IG9mIHNlcXVlbmNlcyB0aGF0IGFyZSBmbGFnZ2VkIGZvcgotICogc3luY2hy b25pemF0aW9uLCBpLmUuLCB0aG9zZSBpbiB0aGUgSU5JVCBzdGF0ZS4gVGhlc2Ugc2VxdWVuY2Vz IGFyZSB0aGVuCi0gKiBwcm9jZXNzZWQgaW4gYmF0Y2hlcywgYWxsb3dpbmcgbXVsdGlwbGUgZW50 cmllcyB0byBiZSBzeW5jaHJvbml6ZWQgd2l0aGluIGEKLSAqIHNpbmdsZSB0cmFuc2FjdGlvbi4g VGhlIHdvcmtlciBmZXRjaGVzIHRoZSBjdXJyZW50IHNlcXVlbmNlIHZhbHVlcyBhbmQgcGFnZQot ICogTFNOcyBmcm9tIHRoZSByZW1vdGUgcHVibGlzaGVyLCB1cGRhdGVzIHRoZSBjb3JyZXNwb25k aW5nIHNlcXVlbmNlcyBvbiB0aGUKLSAqIGxvY2FsIHN1YnNjcmliZXIsIGFuZCBmaW5hbGx5IG1h cmtzIGVhY2ggc2VxdWVuY2UgYXMgUkVBRFkgdXBvbiBzdWNjZXNzZnVsCisgKiBUaGUgYXBwbHkg d29ya2VyIHBlcmlvZGljYWxseSBzY2FucyBwZ19zdWJzY3JpcHRpb25fcmVsIGZvciBzZXF1ZW5j ZXMKKyAqIFdoZW4gc2VxdWVuY2VzIGFyZSBmb3VuZCwgaXQgc3Bhd25zIGEgc2VxdWVuY2VzeW5j IHdvcmtlciB0byBoYW5kbGUKICAqIHN5bmNocm9uaXphdGlvbi4KICAqCi0gKiBUaGUgc2VxdWVu Y2VzeW5jIHdvcmtlciB0aGVuIGZldGNoZXMgYWxsIHNlcXVlbmNlcyB0aGF0IGFyZQotICogaW4g dGhlIFJFQURZIHN0YXRlLCBxdWVyaWVzIHRoZSBwdWJsaXNoZXIgZm9yIGN1cnJlbnQgc2VxdWVu Y2UgdmFsdWVzLCBhbmQKLSAqIHVwZGF0ZXMgYW55IHNlcXVlbmNlcyB0aGF0IGhhdmUgZHJpZnRl ZCBhbmQgdGhlbiBnb2VzIHRvIHNsZWVwLiBUaGUgc2xlZXAKLSAqIGludGVydmFsIHN0YXJ0cyBh cyBTRVFTWU5DX01JTl9TTEVFUF9NUyBhbmQgZG91YmxlcyBhZnRlciBlYWNoIHdha2UgY3ljbGUK LSAqICh1cCB0byBTRVFTWU5DX01BWF9TTEVFUF9NUykuIFdoZW4gZHJpZnQgaXMgZGV0ZWN0ZWQs IHRoZSBpbnRlcnZhbCByZXNldHMgdG8KLSAqIHRoZSBtaW5pbXVtIHRvIGVuc3VyZSB0aW1lbHkg dXBkYXRlcy4KLSAqCi0gKiBBZnRlciBDUkVBVEUgU1VCU0NSSVBUSU9OLCBzZXF1ZW5jZXMgYmVn aW4gaW4gdGhlIElOSVQgc3RhdGUuIFNlcXVlbmNlcwotICogYWRkZWQgdGhyb3VnaCBBTFRFUiBT VUJTQ1JJUFRJT04uLiBSRUZSRVNIIFBVQkxJQ0FUSU9OIGFsc28gc3RhcnQgaW4gdGhlIElOSVQK LSAqIHN0YXRlLiBBbGwgSU5JVCBzZXF1ZW5jZXMgYXJlIHN5bmNocm9uaXplZCB1bmNvbmRpdGlv bmFsbHksIHRoZW4gdHJhbnNpdGlvbgotICogdG8gdGhlIFJFQURZIHN0YXRlLiBPbmNlIGluIHRo ZSBSRUFEWSBzdGF0ZSwgc2VxdWVuY2VzIGFyZSBjaGVja2VkIGZvciBkcmlmdAotICogZnJvbSB0 aGUgcHVibGlzaGVyIGFuZCBzeW5jaHJvbml6ZWQgb25seSB3aGVuIGRyaWZ0IGlzIGRldGVjdGVk LgorICogQSBzaW5nbGUgc2VxdWVuY2VzeW5jIHdvcmtlciBpcyByZXNwb25zaWJsZSBmb3Igc3lu Y2hyb25pemluZyBhbGwgc2VxdWVuY2VzCisgKiBmb3IgYSBzdWJzY3JpcHRpb24uIEl0IGJlZ2lu cyBieSByZXRyaWV2aW5nIHRoZSBsaXN0IG9mIHNlcXVlbmNlcy4gVGhlc2UKKyAqIHNlcXVlbmNl cyBhcmUgdGhlbiBwcm9jZXNzZWQgaW4gYmF0Y2hlcywgYWxsb3dpbmcgbXVsdGlwbGUgZW50cmll cyB0byBiZQorICogc3luY2hyb25pemVkIHdpdGhpbiBhIHNpbmdsZSB0cmFuc2FjdGlvbi4gVGhl IHdvcmtlciBmZXRjaGVzIHRoZSBjdXJyZW50CisgKiBzZXF1ZW5jZSB2YWx1ZXMgYW5kIHBhZ2Ug TFNOcyBmcm9tIHRoZSByZW1vdGUgcHVibGlzaGVyIGFuZCB1cGRhdGVzIHRoZQorICogY29ycmVz cG9uZGluZyBzZXF1ZW5jZXMgb24gdGhlIGxvY2FsIHN1YnNjcmliZXIuIFNlcXVlbmNlcyBpbiB0 aGUgSU5JVAorICogc3RhdGUgYXJlIHVuY29uZGl0aW9uYWxseSB1cGRhdGVkIHRvIHRoZSBsYXRl c3QgdmFsdWVzIGZyb20gdGhlIHB1Ymxpc2hlcgorICogYW5kIHRoZW4gbW92ZWQgdG8gdGhlIFJF QURZIHN0YXRlLiBGb3Igc2VxdWVuY2VzIGFscmVhZHkgaW4gdGhlIFJFQURZCisgKiBzdGF0ZSwg dGhlIHdvcmtlciBjaGVja3MgZm9yIGRyaWZ0IGFuZCB1cGRhdGVzIHRoZW0gb25seSB3aGVuIG5l ZWRlZC4KICAqCiAgKiBTZXF1ZW5jZSBzdGF0ZSB0cmFuc2l0aW9ucyBmb2xsb3cgdGhpcyBwYXR0 ZXJuOgotICogIElOSVQgLS0+IFJFQURZIC0+LSsKLSAqICAgICAgICAgICAgIF4gICAgICB8IChj aGVjay9zeW5jaHJvbml6ZSkKLSAqICAgICAgICAgICAgIHwgICAgICB8Ci0gKiAgICAgICAgICAg ICArLS08LS0tKworCisgKiAgICAgICAoc3luY2hyb25pemUpCisgKiAgSU5JVCAtLS0tLS0tLS0t LS0tLT4gUkVBRFkgLT4tKworICogICAgICAgICAgICAgICAgICAgICAgICAgXiAgICAgIHwgKGNo ZWNrLWRyaWZ0L3N5bmNocm9uaXplKQorICogICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAg IHwKKyAqICAgICAgICAgICAgICAgICAgICAgICAgICstLTwtLS0rCisgKgorICogQmV0d2VlbiBj eWNsZXMsIHRoZSB3b3JrZXIgc2xlZXBzIGZvciBTRVFTWU5DX01JTl9TTEVFUF9NUy4gSWYgbm8g ZHJpZnQgaXMKKyAqIG9ic2VydmVkIGluIGFueSBzZXF1ZW5jZSwgdGhlIHNsZWVwIGludGVydmFs IGRvdWJsZXMgYWZ0ZXIgZWFjaCB3YWtlIGN5Y2xlCisgKiB1cCB0byBTRVFTWU5DX01BWF9TTEVF UF9NUy4gV2hlbiBkcmlmdCBpcyBkZXRlY3RlZCwgdGhlIGludGVydmFsIHJlc2V0cyB0bworICog dGhlIG1pbmltdW0gdG8gZW5zdXJlIHRpbWVseSB1cGRhdGVzLgogICoKICAqIFRvIGF2b2lkIGNy ZWF0aW5nIHRvbyBtYW55IHRyYW5zYWN0aW9ucywgdXAgdG8gTUFYX1NFUVVFTkNFU19TWU5DX1BF Ul9CQVRDSAogICogc2VxdWVuY2VzIGFyZSBzeW5jaHJvbml6ZWQgcGVyIHRyYW5zYWN0aW9uLiBU aGUgbG9ja3Mgb24gdGhlIHNlcXVlbmNlCi0tIAoyLjM0LjEKCg== --000000000000247c7c064c5447b8--