Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkfJZ-0007yr-UC for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 06:11:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkfJY-0003Zb-Ss for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 06:11:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkfJY-0003ZQ-Cp for pgsql-hackers@lists.postgresql.org; Fri, 07 Apr 2023 06:11:12 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pkfJV-0001A3-QK for pgsql-hackers@postgresql.org; Fri, 07 Apr 2023 06:11:11 +0000 Received: by mail-wm1-x32b.google.com with SMTP id l26-20020a05600c1d1a00b003edd24054e0so321139wms.4 for ; Thu, 06 Apr 2023 23:11:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680847867; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=TBy7rHvbP3G7W/4rJJx7YRRvrWJ+UFUYLF2diRaQWOM=; b=bTYb/NI0K3FzrkwNYWSgqCFcT7SJMID7f5revYn+a1iXdacuSJrTz9KmvLt7pOc2RV vRb09cTzI2IwCkk+YQRo0rbGp+mPYXCQD6RNJ9xp8gsuOovzp+lMwdQPYjK1xZFqM0Ae 5ff3TUXY2DV0CuoN2C0E1jtF5iLROlx2yh6veilPcnCOpT9XX9GtlvT8wT0nXPVybpuc TUMWlc2Y/GRGomR/N8VNE6MgQUcezQTIHV+WSre7KpyO9P+iim3ky4gMLb64uo9IF5ih rkhK4JhKztiVuOpBRDXhZomYt5Ahbnx1pPo2M67UgUmxM9b+jb1REtl+nV8SOwJxtgua SBIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680847867; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=TBy7rHvbP3G7W/4rJJx7YRRvrWJ+UFUYLF2diRaQWOM=; b=e6vJXLTQCytBTj02e2ptoWTOh6VqWafHRALmTuOk5OJ2F1pUwEMuBq4Vn160GChdM/ DY8Mm9Zf9hSUOZ8pBmUKNYTjxsFjSgwne/eW4DHDmJApdaGR4uVXcTW4VbTDMICFD1DA E20DV747Ff6Fo1hvTw9FwwIbFEvGH967+fTa7w/wLd5J3Tzy762y2pgK6bs8euZ88/DN EYixKLXSpchbUtRPB/nQKxW2PiQ8q6kOV3HZ/8co6lJpxYh3E6GL4epmbWQqqGIgnxNY 8CGnFE3wT0Eh4m6sVgmgv85w5gfMTDuk3X5197VTTW+wsNJ4iWxyXsWG75iG8rAb7YVA /L5g== X-Gm-Message-State: AAQBX9eTZEOH3+GZMJ97CklvmKzdo8yrNxSaqS9FOh4bZSMTNWUwWY3l JRzrGsyxQcN5cKwHjym8ops= X-Google-Smtp-Source: AKy350aTJB9lubTr0y++WsA0FS9ecqxEd75gsO/jYIB7/WbpXXEc/9iMLZZK/wL5cNXrW6e9NYhVLQ== X-Received: by 2002:a1c:7312:0:b0:3ed:9b20:c7c1 with SMTP id d18-20020a1c7312000000b003ed9b20c7c1mr413588wmb.20.1680847867407; Thu, 06 Apr 2023 23:11:07 -0700 (PDT) Received: from [192.168.26.244] ([54.239.6.185]) by smtp.gmail.com with ESMTPSA id q5-20020a7bce85000000b003ede3e54ed7sm3520253wmj.6.2023.04.06.23.11.06 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 06 Apr 2023 23:11:06 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------TyVbGGV5aOTWDlehLcmM0eGI" Message-ID: <71c3d91a-6b3b-5c0a-ffb9-630f17fe693e@gmail.com> Date: Fri, 7 Apr 2023 08:09:50 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.9.1 Subject: Re: Minimal logical decoding on standbys Content-Language: en-US To: Andres Freund Cc: Amit Kapila , Alvaro Herrera , Jeff Davis , Robert Haas , Thomas Munro , Ibrar Ahmed , Amit Khandekar , fabriziomello@gmail.com, tushar , Rahila Syed , pgsql-hackers References: <8c6e7670-3914-35d1-7977-34f60e598477@gmail.com> <1903ca9b-1dc9-20a6-404a-d4c460c7bdcc@gmail.com> <2b002763-f39f-0814-e98e-c48989ddc3c3@gmail.com> <3c9d4998-a338-081f-a5f6-d038ead75384@gmail.com> <20230407055618.33gjg5vd5hq3kje4@awork3.anarazel.de> From: "Drouvot, Bertrand" In-Reply-To: <20230407055618.33gjg5vd5hq3kje4@awork3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------TyVbGGV5aOTWDlehLcmM0eGI Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, On 4/7/23 7:56 AM, Andres Freund wrote: > Hi, > > On 2023-04-07 07:02:04 +0200, Drouvot, Bertrand wrote: >> Done in V63 attached and did change the associated comment a bit. > > Can you send your changes incrementally, relative to V62? I'm polishing them > right now, and that'd make it a lot easier to apply your changes ontop. > Sure, please find them enclosed. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com --------------TyVbGGV5aOTWDlehLcmM0eGI Content-Type: text/plain; charset=UTF-8; name="v62-63-0005-New-TAP-test-for-logical-decoding-on-standby.patch" Content-Disposition: attachment; filename*0="v62-63-0005-New-TAP-test-for-logical-decoding-on-standby.pat"; filename*1="ch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9k ZWNvZGluZy5wbCBiL3NyYy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9k ZWNvZGluZy5wbAppbmRleCBhNGY5YTNjOTcyLi41YjZkMTlkMzc5IDEwMDY0NAotLS0gYS9z cmMvdGVzdC9yZWNvdmVyeS90LzAzNV9zdGFuZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwKKysr IGIvc3JjL3Rlc3QvcmVjb3ZlcnkvdC8wMzVfc3RhbmRieV9sb2dpY2FsX2RlY29kaW5nLnBs CkBAIC02LDcgKzYsNyBAQCB1c2Ugd2FybmluZ3M7CiAKIHVzZSBQb3N0Z3JlU1FMOjpUZXN0 OjpDbHVzdGVyOwogdXNlIFBvc3RncmVTUUw6OlRlc3Q6OlV0aWxzOwotdXNlIFRlc3Q6Ok1v cmUgdGVzdHMgPT4gNjc7Cit1c2UgVGVzdDo6TW9yZTsKIAogbXkgKCRzdGRpbiwgJHN0ZG91 dCwgJHN0ZGVyciwgJGNhc2NhZGluZ19zdGRvdXQsICRjYXNjYWRpbmdfc3RkZXJyLCAkcmV0 LCAkaGFuZGxlLCAkc2xvdCk7CiAKQEAgLTExMiw4ICsxMTIsNyBAQCBzdWIgY2hlY2tfc2xv dHNfZHJvcHBlZAogCWNoZWNrX3BnX3JlY3Zsb2dpY2FsX3N0ZGVycigkc2xvdF91c2VyX2hh bmRsZSwgImNvbmZsaWN0IHdpdGggcmVjb3ZlcnkiKTsKIH0KIAotIyBDaGVjayBpZiBhbGwg dGhlIHNsb3RzIG9uIHN0YW5kYnkgYXJlIGRyb3BwZWQuIFRoZXNlIGluY2x1ZGUgdGhlICdh Y3RpdmVzbG90JwotIyB0aGF0IHdhcyBhY3F1aXJlZCBieSBtYWtlX3Nsb3RfYWN0aXZlKCks IGFuZCB0aGUgbm9uLWFjdGl2ZSAnaW5hY3RpdmVzbG90Jy4KKyMgQ2hhbmdlIGhvdF9zdGFu ZGJ5X2ZlZWRiYWNrIGFuZCBjaGVjayB4bWluIGFuZCBjYXRhbG9nX3htaW4gdmFsdWVzLgog c3ViIGNoYW5nZV9ob3Rfc3RhbmRieV9mZWVkYmFja19hbmRfd2FpdF9mb3JfeG1pbnMKIHsK IAlteSAoJGhzZiwgJGludmFsaWRhdGVkKSA9IEBfOwpAQCAtNTYwLDcgKzU1OSw3IEBAIG9r KCBmaW5kX2luX2xvZygKICAgJ2FjdGl2ZXNsb3Qgc2xvdCBpbnZhbGlkYXRpb24gaXMgbG9n Z2VkIGR1ZSB0byB3YWxfbGV2ZWwnKTsKIAogIyBWZXJpZnkgdGhhdCBwZ19zdGF0X2RhdGFi YXNlX2NvbmZsaWN0cy5jb25mbF9hY3RpdmVfbG9naWNhbHNsb3QgaGFzIGJlZW4gdXBkYXRl ZAotIyB3ZSBub3cgZXhwZWN0IDMgY29uZmxpY3RzIHJlcG9ydGVkIGFzIHRoZSBjb3VudGVy IHBlcnNpc3QgYWNyb3NzIHJlbG9hZHMKKyMgd2Ugbm93IGV4cGVjdCA0IGNvbmZsaWN0cyBy ZXBvcnRlZCBhcyB0aGUgY291bnRlciBwZXJzaXN0IGFjcm9zcyByZWxvYWRzCiBvayggJG5v ZGVfc3RhbmRieS0+cG9sbF9xdWVyeV91bnRpbCgKIAkncG9zdGdyZXMnLAogCSJzZWxlY3Qg KGNvbmZsX2FjdGl2ZV9sb2dpY2Fsc2xvdCA9IDQpIGZyb20gcGdfc3RhdF9kYXRhYmFzZV9j b25mbGljdHMgd2hlcmUgZGF0bmFtZSA9ICd0ZXN0ZGInIiwgJ3QnKSwKQEAgLTcwMywzICs3 MDIsNSBAQCBvayggcHVtcF91bnRpbCgKIGNob21wKCRjYXNjYWRpbmdfc3Rkb3V0KTsKIGlz KCRjYXNjYWRpbmdfc3Rkb3V0LCAkZXhwZWN0ZWQsCiAgICAgJ2dvdCBzYW1lIGV4cGVjdGVk IG91dHB1dCBmcm9tIHBnX3JlY3Zsb2dpY2FsIGRlY29kaW5nIHNlc3Npb24gb24gY2FzY2Fk aW5nIHN0YW5kYnknKTsKKworZG9uZV90ZXN0aW5nKCk7Cg== --------------TyVbGGV5aOTWDlehLcmM0eGI Content-Type: text/plain; charset=UTF-8; name="v62-63-0004-For-cascading-replication-wake-up-physical-walse.patch" Content-Disposition: attachment; filename*0="v62-63-0004-For-cascading-replication-wake-up-physical-walse"; filename*1=".patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2dyZWNvdmVyeS5j IGIvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZ3JlY292ZXJ5LmMKaW5kZXggY2M0 ZjdiNTMwMi4uZTY0MjdjNTRjNSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvYWNjZXNzL3Ry YW5zYW0veGxvZ3JlY292ZXJ5LmMKKysrIGIvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0v eGxvZ3JlY292ZXJ5LmMKQEAgLTE5NDUsNyArMTk0NSw3IEBAIEFwcGx5V2FsUmVjb3JkKFhM b2dSZWFkZXJTdGF0ZSAqeGxvZ3JlYWRlciwgWExvZ1JlY29yZCAqcmVjb3JkLCBUaW1lTGlu ZUlEICpyZXBsCiAJICogSW5kZWVkLCBsb2dpY2FsIHdhbHNlbmRlcnMgb24gc3RhbmRieSBj YW4ndCBkZWNvZGUgYW5kIHNlbmQgZGF0YSB1bnRpbAogCSAqIGl0J3MgYmVlbiBhcHBsaWVk LgogCSAqCi0JICogUGh5c2ljYWwgd2Fsc2VuZGVycyBkb24ndCBuZWVkIHRvIGJlIHdha29u IHVwIGR1cmluZyByZXBsYXkgdW5sZXNzCisJICogUGh5c2ljYWwgd2Fsc2VuZGVycyBkb24n dCBuZWVkIHRvIGJlIHdva2VuIHVwIGR1cmluZyByZXBsYXkgdW5sZXNzCiAJICogY2FzY2Fk aW5nIHJlcGxpY2F0aW9uIGlzIGFsbG93ZWQgYW5kIHRpbWUgbGluZSBjaGFuZ2Ugb2NjdXJl ZCAoc28gdGhhdAogCSAqIHRoZXkgY2FuIG5vdGljZSB0aGF0IHRoZXkgYXJlIG9uIGEgbmV3 IHRpbWUgbGluZSkuCiAJICoKQEAgLTE5NTMsOSArMTk1MywxMSBAQCBBcHBseVdhbFJlY29y ZChYTG9nUmVhZGVyU3RhdGUgKnhsb2dyZWFkZXIsIFhMb2dSZWNvcmQgKnJlY29yZCwgVGlt ZUxpbmVJRCAqcmVwbAogCSAqCiAJICogIC0gcGh5c2ljYWwgd2Fsc2VuZGVycyBpbiBjYXNl IG9mIG5ldyB0aW1lIGxpbmUgYW5kIGNhc2NhZGUKIAkgKiAgcmVwbGljYXRpb24gaXMgYWxs b3dlZC4KLQkgKiAgLSBhbHdheXMgdHJ1ZSBmb3IgbG9naWNhbCB3YWxzZW5kZXJzLgorCSAq ICAtIGxvZ2ljYWwgd2Fsc2VuZGVycyBpbiBjYXNlIGNhc2NhZGUgcmVwbGljYXRpb24gaXMg YWxsb3dlZCAoY291bGQgbm90CisJICogIGJlIGNyZWF0ZWQgb3RoZXJ3aXNlKS4KIAkgKi8K LQlXYWxTbmRXYWtldXAoc3dpdGNoZWRUTEkgJiYgQWxsb3dDYXNjYWRlUmVwbGljYXRpb24o KSwgdHJ1ZSk7CisJaWYgKEFsbG93Q2FzY2FkZVJlcGxpY2F0aW9uKCkpCisJCVdhbFNuZFdh a2V1cChzd2l0Y2hlZFRMSSwgdHJ1ZSk7CiAKIAkvKgogCSAqIElmIHJtX3JlZG8gY2FsbGVk IFhMb2dSZXF1ZXN0V2FsUmVjZWl2ZXJSZXBseSwgdGhlbiB3ZSB3YWtlIHVwIHRoZQo= --------------TyVbGGV5aOTWDlehLcmM0eGI--