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 1mxn48-0006Lc-Nr for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 09:28:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxn46-0006I3-Sh for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 09:28:42 +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 1mxn46-0006Hu-8w for pgsql-hackers@lists.postgresql.org; Thu, 16 Dec 2021 09:28:42 +0000 Received: from esa16.fujitsucc.c3s2.iphmx.com ([216.71.158.33]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxn43-0000lv-DD for pgsql-hackers@postgresql.org; Thu, 16 Dec 2021 09:28:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1639646920; x=1671182920; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=tgCVQLt1tfbIhFaRehZe5gCz7hq1M33hMgmJs5tSvJE=; b=wi/02yYqOkhAHvzzndeKU+vWbTolFQ+NI3AEmLhQQ433lW7T15mwp48r SUmQSULj6KPRcIXafSu/klzr3p0hPJ2c4pX/KyCemZbvqELgyuVH/siGR mjGYycjLUBa0yxYK8jZvWb8So0VqOO78sOjYZyEWK+CJ7O8SDEMYEvJjU 1Fe9skahwZ1CIhiFDikiRu9+5zsbjzhMV2/8LOIuYpSgNG34XlWEVAu/g idRkF1C0PwATk4S+uGPoQQXN3y7H6KsrToLdnVknYQY9dn/+AtKzc+NJp /O1VenS/GNxUMRXUnFqfVTK7eSGpfIeoOZEr4G9wW71o9L8e880NiX6FK w==; X-IronPort-AV: E=McAfee;i="6200,9189,10199"; a="45982879" X-IronPort-AV: E=Sophos;i="5.88,211,1635174000"; d="scan'208";a="45982879" Received: from mail-tycjpn01lp2174.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.174]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 16 Dec 2021 18:28:35 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BTlZft+FBkRcKf1RfaPTpNyLq+2h0pHFD4dqScsTHeU4XoD3Bc15hhhrUQz2mFPmF+5DQ49IjenzSfR7694mlmOq0EFhg83dQaWMf/apaAYJBr3YhlY51ExvOrGA7oAl2nxQDksr2GUVFCbWDguSSepGiqkqGeIS606aExEAi8+Q1DUhjb+iQ4+m+WMd71G+k+GDRsno0+zVEAEkKWTDe9xSOv6OFDdDLZ8+SGLqtWcsCIroKfBTfGV9nBPeW5z1S5qHEdkT1MFL6wFfs+VBHTN7xofGrwFnks0wZpQlyBfrzKKPN5eq5/mUmzGPXuN+OoriPs6x2NNhDF4PCfpiFw== 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:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=tgCVQLt1tfbIhFaRehZe5gCz7hq1M33hMgmJs5tSvJE=; b=CHoATDKddVBXzGC39C18Cf0tF8AxhbUJDNlvUng18tCaNUojHjAoeDZBJkz4zwviaMFMO5SYFvoDnftJVG5aC5WMN88Od4CG5A7Jkl/olveCeJEa0gq3RdTe6yD3amaqWGPcijejPGd/CRaNGY9zJ/nLnrXfnTS4iGQerhj5sI+Ldupu9ysu0g3A9llQcBWrIzQ8e8J+87hpTJwb2uDE5nbmf5a4DX82saB6XFuHrmMg4nDtIkluNasIvSQ0EjRG2nXz6lNzqVwEr6NQmNhszn6wDwEdQ7PDQL8dvq/hdEAaBaPe7DSPYkRMEEa8lzTyBPz9ow195aqP+XoQiBI4dA== 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=tgCVQLt1tfbIhFaRehZe5gCz7hq1M33hMgmJs5tSvJE=; b=mfA4Sr0vTieXBGeVVF79g8YVf8xlnu6q2oB1zmrSlpMi6Ud0liemUEIgLgFSd9+Qx8lcYwGHoefbwd56cK7KzxcMI1vM/mmc0vAqCexvy6BLUsPj/JO1BTWU8RTxZOuEgXiixAdEAwZgw6VHhX7oszL21sbiwoauMChx0xJwPhM= Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com (2603:1096:604:bb::12) by OSBPR01MB4854.jpnprd01.prod.outlook.com (2603:1096:604:39::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4778.17; Thu, 16 Dec 2021 09:28:29 +0000 Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::40b5:724c:8c41:b012]) by OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::40b5:724c:8c41:b012%4]) with mapi id 15.20.4755.026; Thu, 16 Dec 2021 09:28:29 +0000 From: "houzj.fnst@fujitsu.com" To: Alvaro Herrera , Rahila Syed CC: Amit Kapila , Tomas Vondra , Peter Smith , PostgreSQL-development Subject: RE: Column Filtering in Logical Replication Thread-Topic: Column Filtering in Logical Replication Thread-Index: AQHXbedBXHBQh3Nzm06CtHX1K4V/oqs4douAgAaeiQCAAEX8gIABtBYAgCk07wCAAPLrAIAEPEQAgCCfo4CAAMATAICcUtYAgAAShACABH3wgIAAAQUAgAQpJXA= Date: Thu, 16 Dec 2021 09:28:28 +0000 Message-ID: References: <202112131744.kw5vn6x4yvzo@alvherre.pgsql> <202112131747.cmlstdewm4kh@alvherre.pgsql> In-Reply-To: <202112131747.cmlstdewm4kh@alvherre.pgsql> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: dd1e7c3f-10c8-45a3-f4d4-08d9c0766b63 x-ms-traffictypediagnostic: OSBPR01MB4854:EE_ 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: 3oF8GQqNCR2afc0TevsW/lXRJJd8WYa4LL9qJNdK2m/Ln/l6nWjCHDKtc1aHOv721F1wY1e+NhUD64s9AsyXgIbB9Dv4HXpifWSCjZ+PxysoYdc5FcbKiJryOkFr2OM8M3n8lECTBwn8J0zOeyap25sBtVT92dlnUa4eAbQBn8jwRNsjVv+72nXETtst0yS+Vpo9Tn2mLBJSmkeT3yovFPDBKemfB+ffZOjZS1uBQ8uOUnOX0+un0V++fQTEo0GD96DQVutcQ/75tRH2cT29uktFNBa7LQZojLQInjmEZKRvqBYM+nbG/waMqAZKZqDQABXK3FWLLmyo7xWPXKlosLiK6t5wpNZ6DxZESzI+z1ngpHUNKUdbv7oAlZFQNkBGpeYrbEWR21eVoOpI5xHRKt4McKEyPYVG1OkcMD/WqF8K9CHp4rVFd28lzSzNbbsrHVoDmO6nX8ZevAKx4M4J9cpmnsj1CCE4P4W+D7bF5dVH6igCTpuxMo/55k6xD2DdJkVRmlXiGECmS/qkEr6zKT3cUA6Ery0cOFWV9fObiLy7n/VtRjZFepQle7F/VTFzAeLy6k1jeMJI8+h4amQMG1Sy6qF0db2QhacGvuGxhNBjJNiCOToUs6rPZZtDwZaVcoUohG16/ii0YB4/dwBhH2wSzqiocR39ALL3RTMejbcvEjSAG+J0Y75ssccVfOgdQTNkd3+aTZFmuZOaShL60oB2de+u95Ybcc80uGzrfUo= 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)(38070700005)(110136005)(4744005)(66446008)(9686003)(66946007)(86362001)(316002)(122000001)(85182001)(8676002)(55016003)(66476007)(71200400001)(76116006)(82960400001)(52536014)(5660300002)(64756008)(4326008)(8936002)(54906003)(38100700002)(2906002)(66556008)(33656002)(6506007)(508600001)(7696005)(26005)(186003)(366874004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?ZVNzWXhmZnU3RFN6bTgxL0Z3SFdrenRuVzlOWXdpZVNSa2lrWjJtZnRYZjlq?= =?utf-8?B?K1ZsT09tRDFkR3ZsN0Ftd0RHbjFJc0V6U0RBSjhvcUZuTVA0eGg0TGVaR1Vv?= =?utf-8?B?TE56bEd4QmhOQ1ZqYkRscWE5dkJDSjRicTRyeHRYdmFlaU9abm9WVHEwZGRp?= =?utf-8?B?a05Tc1RvN01NYTEwZ0VPWFFnSUtMREQ0VUxIS1A5TmFrMkk3Z3d3VElnYTJF?= =?utf-8?B?anZac1dMNFNvZUgwWm02WjZMMFEwakxNeTRxRDJuaHJGaUtoWlhtQXp0WlpQ?= =?utf-8?B?RXFUNzNRZDE0VFh5VEUwOEVjbUVPZVEyaVp6YTBIN2tWdTlZd25LMzZLR2dv?= =?utf-8?B?RU5vT0c3QU9VcURYSlpwRXcyMXdBdWZLSVNYQ29TK0dzR24yazBoTUxDQmVH?= =?utf-8?B?NFBHc1JKSFQwQTlMZDZZRnlnYVNRclpML1lzd3k5YnJxUUtNbGJsenptRWxD?= =?utf-8?B?STNzbjJITHRvMFA4YWJBeFliSFp5SnRHdmQzM0VscTFwcXhVZ2dnUmJ0VGZm?= =?utf-8?B?dUJtcFZLbnpYZEt6ZU04K0FRZjBNOXVjZEc4WE0yLzNKZ1pvR01RayttaGx6?= =?utf-8?B?cXVoMjl3NXRzYzhGRmJMbDlLc1hlT1NFWEJwakhsYTErZzZ2V2FFbXBCZ3RK?= =?utf-8?B?TkpYdE92MTFiSmJqb3ZkQzlteXNlakxITDZlSno1d3RnelpORWlEWklybzUy?= =?utf-8?B?VzF4NkNKUVZqTzRHRk13N3lvUUVLTW11ZDIyNGJ4ZDNqeWx0eHFFSEEyamdl?= =?utf-8?B?TGZiZEVsZm5XOUt2YzdWOG9MUnZWd0tnMkY5Uzgxc2MvN21xbXJDdlY0MjF4?= =?utf-8?B?S2JkcjRZNG9qbXF0ckRGLzhZSCtXNTl2V2lHTG1qd2pWMzdTVEYyRmlyKy9S?= =?utf-8?B?THBUNTI0RTdTUEE1alQ3M1NKMGJkdDkwa3FVRHlFZFNlNEdqZkNmTUJOcHcr?= =?utf-8?B?M1JIQzFmYVVlY3lDT0h3d2RaMC9xNSt4NG90Skp3azZ3eUxHTEZkNENqMFpk?= =?utf-8?B?ckJVUHhBN2g3VDRINXpwTXF1T0g0R1MwQ2hXU3B5Q0ZCNDI0SVBXaTFvamFk?= =?utf-8?B?RzNzSVJiK04rN2lTdDk0ZUQxWFArUVJRbHA0OU9aamNtL2JabE5NeWV6eWRH?= =?utf-8?B?UDBNb3h5NGxuSFV4bDhWY1pWS0w5ME0xOWFCTS94d3JSQ2VXd1d4S1F2UlZZ?= =?utf-8?B?MU1UYjJjbTRKNFo4aWtnQ0xBY0VGL04vdmQwVGp3WFJpUm5wRVRFVzF3Sklk?= =?utf-8?B?Vjd1V0I0NjVHVUhBNk9VM01aTzhWelJTUnJYbEdIOVJXSEdNelVqTWZUNnBK?= =?utf-8?B?SXgrZVphak92d1N6NTRiaHIvMnpuU2pyQS8vM200ZmFZc1dEMG1ERjdpUnZX?= =?utf-8?B?aU9KSUlrSVZJczZYRENUb0xhNmVZWTlxSVdsQzR4cnhjOG8zLzdyNHVXT1ZP?= =?utf-8?B?R0dvbDNhODVrSU1vOVB0S20wWlVpSkIxdHd4b0hwTkhraDlmUzVjRlRrRWRL?= =?utf-8?B?VDkzelViWVNRcVd0cU12ZmNXaW1zcDl4NytjOU9mZFBkK003d3IyU3ZZTGIw?= =?utf-8?B?MTJ1MnhQd0pPcDl5Q3BLWXRtSjFRSC8vQ1lMV2RhQk41aXluNTRMeDEzM3Fj?= =?utf-8?B?Zng4MzJWeXhXS2ZFUVZjZXQrbFl6UTNPS2RKcEduT3E4OFRBSUZFTzNPelo3?= =?utf-8?B?ck10NzNGL01HU0ZSVzMvM2JZZ2QxTEN5YjFtbG9WR1hnVHJ3SUtYRVN1WlYx?= =?utf-8?B?Z2JucUxTdFJLck0vTy9pV1pxWGo2S0hwL2NHb0VNQkhsWEdTcUFzbFV4andG?= =?utf-8?B?cHZQSFJSTGpHbDl0ZXpibEpES3VaNWxxbDFIcmNtNkdJTUZKQmJ6anFqOGpa?= =?utf-8?B?OExzMExRbUlKRHlVL1dvVWdMdHpUR1IvYk90ZXp3clJBaWVtZkY3ZGpucURw?= =?utf-8?B?NkV1MDkwb1I4V0ZzWFJsNDI3a2wvUGt0UnFnT05EUXVGYkhGa0RLRVY2Vko4?= =?utf-8?B?MDB2MkYyZ2FIZHVxcmdGb2NMeDNLY2NlRDkzbVNGYUNWTUNVTjkwRndBd25m?= =?utf-8?B?S2d1TythWHE5Z2twRDkzZ091YmdHWVJTQk5lbXp2dTQ5Q3lDVk5LazJEQmh5?= =?utf-8?B?Q3hTQlJxNUJreE1yVE9DdnNzc05wdEVhei90TkpyTzZUdEw0T0M4YjBMeU5Z?= =?utf-8?Q?NhaIbyltERjbygZoqOXptxk=3D?= 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: dd1e7c3f-10c8-45a3-f4d4-08d9c0766b63 X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Dec 2021 09:28:28.9085 (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: wKz74xBSDce6TEAugNNRdpAcJiX+FOpRleQbLS+WPVd6Mdqo3LGbrIgKtcOyrXdH0IjdAAOp//9EsSAKpFBhaw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSBPR01MB4854 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlcywgRGVjIDE0LCAyMDIxIDE6NDggQU0gQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFs dmgubm8taXAub3JnPiB3cm90ZToNCj4gSG1tLCBJIG1lc3NlZCB1cCB0aGUgcGF0Y2ggZmlsZSBJ IHNlbnQuICBIZXJlJ3MgdGhlIGNvbXBsZXRlIHBhdGNoLg0KPiANCg0KSGksDQoNCkkgaGF2ZSBh IG1pbm9yIHF1ZXN0aW9uIGFib3V0IHRoZSByZXBsaWNhIGlkZW50aXR5IGNoZWNrIG9mIHRoaXMg cGF0Y2guDQoNCitjaGVja19wdWJsaWNhdGlvbl9hZGRfcmVsYXRpb24oUmVsYXRpb24gdGFyZ2V0 cmVsLCBCaXRtYXBzZXQgKmNvbHVtbnMpDQouLi4NCisJCQlpZGF0dHJzID0gUmVsYXRpb25HZXRJ bmRleEF0dHJCaXRtYXAodGFyZ2V0cmVsLA0KKwkJCQkJCQkJCQkJCSBJTkRFWF9BVFRSX0JJVE1B UF9JREVOVElUWV9LRVkpOw0KKwkJCWlmICghYm1zX2lzX3N1YnNldChpZGF0dHJzLCBjb2x1bW5z KSkNCisJCQkJZXJlcG9ydChFUlJPUiwNCisJCQkJCQllcnJjb2RlKEVSUkNPREVfSU5WQUxJRF9D T0xVTU5fUkVGRVJFTkNFKSwNCisJCQkJCQllcnJtc2coImludmFsaWQgY29sdW1uIGxpc3QgZm9y IHB1Ymxpc2hpbmcgcmVsYXRpb24gXCIlc1wiIiwNCisJCQkJCQkJICAgUmVsYXRpb25HZXRSZWxh dGlvbk5hbWUodGFyZ2V0cmVsKSksDQorCQkJCQkJZXJyZGV0YWlsKCJBbGwgY29sdW1ucyBpbiBS RVBMSUNBIElERU5USVRZIG11c3QgYmUgcHJlc2VudCBpbiB0aGUgY29sdW1uIGxpc3QuIikpOw0K Kw0KDQpUaGUgcGF0Y2ggZW5zdXJlcyBhbGwgY29sdW1ucyBvZiBSVCBhcmUgaW4gY29sdW1uIGxp c3Qgd2hlbiBDUkVBVEUvQUxURVINCnB1YmxpY2F0aW9uLCBidXQgaXQgc2VlbXMgZG9lc24ndCBw cmV2ZW50IHVzZXIgZnJvbSBjaGFuZ2luZyB0aGUgcmVwbGljYQ0KaWRlbnRpdHkgb3IgZHJvcHBp bmcgdGhlIGluZGV4IHVzZWQgaW4gcmVwbGljYSBpZGVudGl0eS4gRG8gd2UgYWxzbyBuZWVkIHRv DQpjaGVjayB0aG9zZSBjYXNlcyA/DQoNCkJlc3QgcmVnYXJkcywNCkhvdSB6ag0K