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 1mR67M-0004ya-GN for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Sep 2021 05:08:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mR67L-0007Z2-4g for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Sep 2021 05:08:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mR67K-0007XW-Ac for pgsql-hackers@lists.postgresql.org; Fri, 17 Sep 2021 05:08:54 +0000 Received: from esa11.fujitsucc.c3s2.iphmx.com ([216.71.156.121]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mR67B-0003P5-Ej for pgsql-hackers@postgresql.org; Fri, 17 Sep 2021 05:08:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1631855325; x=1663391325; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=7UqZPz+ilUxAQZ1vvoVmKocs0gDR+A6I5R5YKWgqUFQ=; b=tJbFapFD0J9jjEWyNZNl1dm3HVgMlRJGkHIy4SPSb/WIvpyvgkIpT4gP OcxARE02+YOXrSKduppPstolmmgzD8qYuscv0pbVWI0UKyqV49K153/kt NEE7dX8tHZsKbm7gLGt2jsi63V8frKr1KI8y55BfICfr7hOcoJJ0PX/0x Z+5i42Jrfl4y6adwtxRS5eQVeg5ZuyC68dZTob2mCYtGuE+calYH/phVw vmPct/lHdqRQau096lg+vC8yF2Ub9VjD2vMogAqFk6hBa/5nAK7ZWxgbq TT0DHtQ1oICdqi5wz/8OY+aCfiqwLjigl2AiBPlwFdlQGVLkdgGH88Ylz A==; X-IronPort-AV: E=McAfee;i="6200,9189,10109"; a="39573559" X-IronPort-AV: E=Sophos;i="5.85,300,1624287600"; d="scan'208";a="39573559" Received: from mail-os2jpn01lp2056.outbound.protection.outlook.com (HELO JPN01-OS2-obe.outbound.protection.outlook.com) ([104.47.92.56]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 17 Sep 2021 14:08:39 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=oGJSW6QYTLxU3LndXW3WYF59QzSy0ElMwBTtTV/R56BMIj6Id2E2ICADtYZ/midhylBm0A6wqrT6fN02x+7wrGmE90HkT3BibWqxjIyBEX/blCbiIc6v0CLWCKboqgbl4ycZZhU5zoPR0tboidtOkN8rkBTOMaWZe3m7s2GX04E9Jt2lIoixKwwZcGRDUJoTgUmORIk4SkaPyBxN1HB/lKaFyGs33fZYniaw08nqCg7SGpJ4Biqc0OJkN8pDGOEXx37ca/FuEHvbFy/tMxzo7Tzq34nCqCe5vmQ27dPLCq8M42nOQ4GpQdTsQRuTPDKlU9nEDdK1Z9OLYRvmZf0Uuw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=7UqZPz+ilUxAQZ1vvoVmKocs0gDR+A6I5R5YKWgqUFQ=; b=ec0v/zAI5V5/9SxPfqEcCi53Ez1fBkl2O5a2GnqFMjsW61QGUPZflL2n+4UEa0eGLZeIDPOA3/SZUBxJZvxZc+drp6Of2XECK9OoLioBpCXlpk4r3+L1sAf2hPZVyiydpQC5QO3qlN163/D1LjpO5pnuPie41pbLringlugtlJ0iHt4Thh5ZbtIXAT3jITl5sG/106G1dhcV4wSp7XdcogANpwsKVMWzEGsmGhhtzFNFy2IpT6BofUrDPC0Kv5pSXdti9tIE/U0psc0x5YpRVs2iihs+n95UrkvfLR3TnoQV0XeMiyiRSlDq7HOiK4WCAppR8mBTaADbfrvVsMt0dg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=7UqZPz+ilUxAQZ1vvoVmKocs0gDR+A6I5R5YKWgqUFQ=; b=QRww3y3StV7KkICc74DpqmmNo5TNmbzd61mX8R/OvasQ/KmtYcQIkSg0YuEIzlIqJ6mKiKJpQLpNfBGLQKRNw4sCf0WQeNP96eVcEapRy4UKMAQwkPXTC8IX4iQXPA86EaO8NGSowgiDoXUGkbAnDyVQkS/CZ+Zw6wyOQi4z8tY= Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com (2603:1096:604:bb::12) by OSAPR01MB1731.jpnprd01.prod.outlook.com (2603:1096:603:2b::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4523.16; Fri, 17 Sep 2021 05:08:37 +0000 Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::59be:7421:34c7:202c]) by OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::59be:7421:34c7:202c%3]) with mapi id 15.20.4523.016; Fri, 17 Sep 2021 05:08:37 +0000 From: "houzj.fnst@fujitsu.com" To: Alvaro Herrera , vignesh C CC: Amit Kapila , Rahila Syed , Tomas Vondra , Peter Smith , PostgreSQL-development Subject: RE: Column Filtering in Logical Replication Thread-Topic: Column Filtering in Logical Replication Thread-Index: AQHXbedBXHBQh3Nzm06CtHX1K4V/oqs4douAgAaeiQCAAEX8gIABtBYAgCk07wCAAPLrAIAEPEQAgCCfo4CAAMATAIAC1xcAgACv5gCAAmdlgIAA0h8AgAAgdQCADTVlgIAAioSAgAAIKYCAAATmgIAA9WyAgAAew4CAAJK0gIAADOIAgADy6lA= Date: Fri, 17 Sep 2021 05:08:36 +0000 Message-ID: References: <202109161350.kccziuuu25ex@alvherre.pgsql> <202109161436.3z5fhpsalhs3@alvherre.pgsql> In-Reply-To: <202109161436.3z5fhpsalhs3@alvherre.pgsql> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: alvh.no-ip.org; dkim=none (message not signed) header.d=none;alvh.no-ip.org; dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 60b21ace-1279-4c02-28a3-08d9799934b9 x-ms-traffictypediagnostic: OSAPR01MB1731: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8882; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ek0htc3d53n6g9Rs2tDcsK8iOpTvuI6aqkCQBPl+9bTZiYzfpcVC7nQuzNb6hERdZiZGnGbW3iLg8ghqebky/llDvriKx8wwViT+kz3hfVZMKvW3ynki7B3yL4LpETJKnkYn7ttjAIBi/NTkbzGXCPbHGMTxeafvjGhhFblNKIdAd//l/Q1jx/lQY6wo7WCQKrR0vGyrs0nn2hrq7lAQdFXwRI6FrSq/seNVotAlCuBOSyRk4zmvvHIYloYC3AOihcgN2lKM3X6bZlNRJPzwORE0ehwtKihh5HlDTq8t28TB1GWPcq6NxLWRwZhNjZliB/Bk4zVFU3D8AkR2Q2oe+1xxyAMo1Isnp/Bbnh02DmzLZuhbwP52iGofDGMeH6Q6hqsmqK1RAlcGgn0jrrP41XYIizVOVgfcjJegq5ZUlqcvKYkKiEMfG2wbccFZu4289f+zgxTB0kKv9gPw7rJsXfQbWppStVMAlqyURPOloctX8F1XhDoRyFbpxOIJ92wgRJgGXiFaKYWwzwNU8vBBFYwW/d/YQ6GvNIZZgV0Nu/XvP2n4/kUHFGHr8vSUDSm7CrOZV57yAMs0V3DzZnkUDyA7BiVHFs9yk/Nfgn6omdU+1MLXp+byUTOeowV+uhkDY6F06SBkbZritt4kQs7CQlvEl/g/D6zVJgVmIdvUJifNM/rLsSMASiGIMM8U7mDrx1pV/Ilxy19PuUlsO0uX7ufAlceqYsv24pvEMsp+h9UOSDEIs6XwkSZzR1ycUDbyzg1/YXBJCcDQbzrlNRgU6tpvc1EeOLvAUp8EcBjGx7U= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS0PR01MB5716.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(5660300002)(38100700002)(2906002)(71200400001)(38070700005)(4326008)(8676002)(52536014)(76116006)(64756008)(8936002)(66476007)(66446008)(66556008)(122000001)(966005)(66946007)(83380400001)(86362001)(186003)(9686003)(85182001)(508600001)(26005)(110136005)(54906003)(316002)(55016002)(6506007)(7696005)(33656002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?VlFPcjYycjN5dkNFa2cvTngyd0VVSW0zRWk4ZXdCS0U5YjhzalBWeFdzaTA0?= =?utf-8?B?Q1dURnZKUzhrK25WODdyZWNrN0ZJTStqZnFMVE5renJzeWJMa0JHc20vMmxy?= =?utf-8?B?bGZFUndLWkZYS0M4WmZkUUVRZGllMWZQV0xFK2luRW9rRmFCZjh3ZXEvSXJO?= =?utf-8?B?MTFFWlczMXg2d25LSTJDQkg0VHpFbFlvYS9xcDdXZ3J4azJodzRZcFJ4OUts?= =?utf-8?B?aGJaRkdTYi91eXZFYk83cU9mb3VpbWR2NG1QaXl5TkRxZEFqaVJiKzk0Z09H?= =?utf-8?B?djlmbGRtbzgxVVloREt6Z1gvamNhQ2xjZUZHS25qeTBwTEptWjM2SkF5b0Jo?= =?utf-8?B?YmJxOHBnUWIrWHc2bVZmdk9qRVBrWkVTVk5wSVBNR1FWRWpreUwyWnVEa3RC?= =?utf-8?B?UWN4dUZIVGIzL0xWaThmOEtFclhSblNkMjFUb3ppRkJGMnlsQ0o5d25aL3pT?= =?utf-8?B?Y1NRRzc3andrZk1NM09jcXIwVXZaVjhsUkxvWmY0R1ZSTHpKTjBSTDhXbkhq?= =?utf-8?B?MEFOMXA0S2MvWkJibXFuMWdNZStzdnlpYjFLSE80RDZZY2RXcE9oZ1J3ZmJP?= =?utf-8?B?STVCYjl2VXcyWklJVUJWZEZTTUdJbUgySGhDMHBJeERmUHJNUUJORmNabWx6?= =?utf-8?B?b1VuZHNaMGY5SUI0eUJZM1ZMNm9OV2JYWGFHRTAxZFd0MThlMjRzb1dXcnpq?= =?utf-8?B?MndrN2syYVlOcjZPa0RobmJVSGNuMFRPdnh0QmhBMlI5dnpXbDRlUk9qUjg3?= =?utf-8?B?UDNLS28vNjlWRHpNZHYvTHJ4aTM4ZUM4aktLTU1UOVJaek9sQVljM0gzbFky?= =?utf-8?B?ZDh0ZDZHcTBWVnlEaU9SVVUvd2pmTWRQV3U1LzJxQjhadWRuYW9WKyt0elRJ?= =?utf-8?B?TDJKSUh0Z0NvZW1hc21HVFNJQ1Bjbk9Rc0oyRkdMQllyckVpSmY4V1pSbWow?= =?utf-8?B?WVZvcGE0MGJUeStleFQzbjUvOVhtUWZ0eTI0dnV0aXhLakt3SzdWK2ptY1lR?= =?utf-8?B?V1A0SnJkR0luZE9JNklRTWlSTlZkemdmWVg5QmNtVTdZRnFKaTI0Ri9YQzd6?= =?utf-8?B?djlDWldZTnFOMDJXcmtWYTRjMHYvaHRDbFJscTIxTmJtcjV1bDFZaWVxYzA1?= =?utf-8?B?LzJ4UFI5Ri96TjVXZjN4NzlKbVpnTnpyLzV1b253dDFZWHAxUzJtVEhuRzBZ?= =?utf-8?B?aEVDcTkzR0JNaDFDQjN1aHFQSkt2bUdqNDcza2dKYXBETlBwN2NkVGh1M250?= =?utf-8?B?MWgwZWl4R2tBZUZlcDB3WmdUL3djNHVJeDNWRVlybE9Iam9JVElUOTU4ejNZ?= =?utf-8?B?RXJQQ2NVeXB1SlRQV1RVQ2FhM2w2Z3Y5TlJRM2RvdWhaMnhieWdQWTZGWjZR?= =?utf-8?B?THZTKytmWFpod1FCNkM0SnpnMFArYTEyU1g0Tk5BSTUwUUE2eUdtL1k1bEpl?= =?utf-8?B?VHlwZkZINCtsTVlMaVA0YVV2cVIxcER6Ymg5cFFOc0VteVdyQlJwdlhqMDh3?= =?utf-8?B?WXlFajVEUFVrWnpzaEd1U1FlZ3AyMEJzM0ZPRmgzYXFLeGRqeHVHUm9KRlNG?= =?utf-8?B?YTZGaUtLQWtGcW5qUGJTaWdacnRjMWNvNGRrKy9VT3BudnlUWkprQ01aaHpJ?= =?utf-8?B?T0RXeGZRZ2RvYnV3UXZlaGdiZVlqdlp5VUpCek53ak5TWFZLaEMva3gvd1lo?= =?utf-8?B?cEo4SXZBZ2FicW1kSENIOTBaWTlybkc1T1NWQlVrbEphUDVZWFF5QklmWWo4?= =?utf-8?Q?+XGwXpoL3BJBlRIapIoINtZdhln//cM1CIx7Jo+?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS0PR01MB5716.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 60b21ace-1279-4c02-28a3-08d9799934b9 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Sep 2021 05:08:37.0545 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: FhxZpNzzoqMIVJJwXLNbVGXwgrfQY+K+Wrt4LglCTqxk1ShX2NrCMKEJ2qWGMfyEWniLQyaHOKktdxd+yCiNFQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB1731 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVGh1cnMsIFNlcCAxNiwgMjAyMSAxMDozNyBQTSBBbHZhcm8gSGVycmVyYSA8YWx2aGVycmVA YWx2aC5uby1pcC5vcmc+IHdyb3RlOg0KPiBPbiAyMDIxLVNlcC0xNiwgQWx2YXJvIEhlcnJlcmEg d3JvdGU6DQo+IA0KPiBBY3R1YWxseSwgc29tZXRoaW5nIGxpa2UgdGhpcyBtaWdodCBiZSBiZXR0 ZXI6DQo+IA0KPiA+IFB1YmxpY2F0aW9uT2JqU3BlYzoNCj4gDQo+ID4JCQl8IFRBQkxFIHF1YWxp ZmllZF9uYW1lDQo+ID4JCQkJCXsNCj4gPgkJCQkJCSQkID0gbWFrZU5vZGUoUHVibGljYXRpb25P YmpTcGVjKTsNCj4gPgkJCQkJCSQkLT5wdWJvYmp0eXBlID0gUFVCTElDQVRJT05PQkpfVEFCTEU7 DQo+ID4JCQkJCQkkJC0+cHVicnZvYmogPSAkMjsNCj4gPgkJCQkJCSQkLT5sb2NhdGlvbiA9IEAx Ow0KPiA+CQkJCQl9DQo+ID4JCQl8IEFMTCBUQUJMRVMgSU5fUCBTQ0hFTUEgbmFtZQ0KPiA+CQkJ CQl7DQo+ID4JCQkJCQkkJCA9IG1ha2VOb2RlKFB1YmxpY2F0aW9uT2JqU3BlYyk7DQo+ID4JCQkJ CQkkJC0+cHVib2JqdHlwZSA9IFBVQkxJQ0FUSU9OT0JKX0FMTF9UQUJMRVNfSU5fU0NIRU1BOw0K PiA+CQkJCQkJJCQtPnB1YnBsYWlub2JqID0gJDU7DQo+ID4JCQkJCQkkJC0+bG9jYXRpb24gPSBA MTsNCj4gPgkJCQkJfQ0KPiBTbyB5b3UgZG9uJ3QgaGF2ZSB0byBjcmFtIHRoZSBzY2hlbWEgbmFt ZSBpbiBhIFJhbmdlVmFyLCB3aGljaCB3b3VsZCBpbmRlZWQNCj4gYmUgcXVpdGUgYXdrd2FyZC4g IChJJ20gc3VyZSB5b3UgY2FuIGNvbWUgdXAgd2l0aCBiZXR0ZXIgbmFtZXMgZm9yIHRoZSBzdHJ1 Y3QNCj4gbWVtYmVycyB0aGVyZSAuLi4pPiANCg0KRGlkIHlvdSBtZWFuIHNvbWV0aGluZyBsaWtl IHRoZSBmb2xsb3dpbmcgPw0KLS0tLS0NClB1YmxpY2F0aW9uT2JqU3BlYzoNCgkJVEFCTEUgcXVh bGlmaWVkX25hbWUgey4uLn0NCgkJfCBBTEwgVEFCTEVTIElOX1AgU0NIRU1BIG5hbWUgey4uLn0N CgkJOw0KDQpwdWJfb2JqX2xpc3Q6DQoJCVB1YmxpY2F0aW9uT2JqU3BlYw0KICAgICAgICB8IHB1 Yl9vYmpfbGlzdCAnLCcgUHVibGljYXRpb25PYmpTcGVjDQotLS0tLQ0KDQpJZiBzbywgSSB0aGlu ayBpdCBvbmx5IHN1cHBvcnRzIHN5bnRheGVzIGxpa2UgIlRBQkxFIGEsIFRBQkxFIGIsIFRBQkxF IGMiIHdoaWxlDQp3ZSBjYW5ubm90IHVzZSAiVEFCTEUgYSxiLGMiLiBUbyBzdXBwb3J0IG11bHRp cGxlIG9iamVjdHMsIHdlIG5lZWQgYSBiYXJlIG5hbWUNCmluIFB1YmxpY2F0aW9uT2JqU3BlYy4N Cg0KT3IgRGlkIHlvdSBtZWFuIHNvbWV0aGluZyBsaWtlIHRoaXMgPw0KLS0tLS0NClB1YmxpY2F0 aW9uT2JqU3BlYzoNCgkJVEFCTEUgcXVhbGlmaWVkX25hbWUgey4uLn0NCgkJfCBBTEwgVEFCTEVT IElOX1AgU0NIRU1BIG5hbWUgey4uLn0NCgkJfCBxdWFsaWZpZWRfbmFtZSB7Li4ufQ0KCQk7DQot LS0tLQ0KDQpJIHRoaW5rIHRoaXMgZG9lc24ndCBzdXBwb3J0IHJlbGF0aW9uIGV4cHJlc3Npb24g bGlrZSAidGFibGUgKi9PTkxZIHRhYmxlL09OTFkNCih0YWJsZSkiIGFzIG1lbXRpb25lZCBieSBW aWduZXNoIFsxXS4NCg0KVGhvdWdodHMgPw0KDQpbMV0gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvbWVzc2FnZS1pZC9DQUxEYU5tMDYlM0RMRHl0WXlZJTJCeGNBUWQ4VUtfWXBKM3pNbzRQNVY4 S0JBcnc2TW9EV0RnJTQwbWFpbC5nbWFpbC5jb20NCg0KQmVzdCByZWdhcmRzLA0KSG91IHpqDQo=