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 1n1puF-000705-UO for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Dec 2021 13:19:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n1puE-0003Fo-Op for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Dec 2021 13:19:14 +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 1n1puE-0003Ff-EQ for pgsql-hackers@lists.postgresql.org; Mon, 27 Dec 2021 13:19:14 +0000 Received: from esa14.fujitsucc.c3s2.iphmx.com ([68.232.156.101]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1puC-00007I-Pk for pgsql-hackers@lists.postgresql.org; Mon, 27 Dec 2021 13:19:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1640611153; x=1672147153; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=OVVNqNzaEHDE+Jgyw1f0jLhvt6gU9h1CQBbxmnVLoKY=; b=TtmhWILk5GarmxgUvwq6Vz51tPEiaUtaQP5CbZ1ObHqbvjD4qSRUi53l 9iVR28G+YXUUapJCzUusLq+vq2zku1m/8hOlXF3Z0m5oVD7VEU+hY5mzf 8FT8WaZQ95XonbUBP4n+2J3i9rKXZYi7IrNQHoh5KctzptlKWk/qVQ30u 9PyrZABb3IgYcByqMPsIE1OXNxrcx5e/FbWruW4J2R/vSB7Adqzq8ynBN AnyjsLoZ6gtZ/pVZGclYyTlqiO5gQxTNiwbfpi7/vM6SYN32o1TdZzksT gbIvgzU7qZtBhs0K9GD2xh7h+Fj0yrGPAE4QlXu90RWgPtDfpGytZR+9S Q==; X-IronPort-AV: E=McAfee;i="6200,9189,10209"; a="46555997" X-IronPort-AV: E=Sophos;i="5.88,239,1635174000"; d="scan'208";a="46555997" Received: from mail-tycjpn01lp2169.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.169]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 27 Dec 2021 22:19:07 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=hCsMruaIBIbs5gCuorlcSI1gNenHo2pLK9M7FmiDS4RU+L+QXAXx46zWYOWeuXy94OWABzgjX39Jd5viP14+XNUtyAw6jiZhkAyXY23otHizvrsU+jxyYBAQ3BgJVIieM8dJEq0aLX14UHi9+40JJEVnHEq4k/vCsCCQYQzkSRvAMa7dk/SzzgqDfIs+hzhTqLwzbUPQhjLIAl7LshPN2snZtBj/5TijVwDU7rWJ4/fh+EHtyznXudI2DeK/yuv5Upl+YGe9IwhN5UUBBkPcGCmHc4iBAQ76t4FBMYZ4/7lNHfbDjr2N8ESifAd5VozB9g5p0FE2MzE9jPTT1X91dA== 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=OVVNqNzaEHDE+Jgyw1f0jLhvt6gU9h1CQBbxmnVLoKY=; b=HFLwnh3dVBRJokLjwS6z0VNqMkSBpYAml4HZmZm7Vgw67QwtcgPrUUg9Pq14C4/iDQPEoE2kSknclsZ2eacO5zDcCewiT4rhBwvQiOWfiPJ6fizcnR3PgoHDCnsvFdhttNk9l7oaUB5BtXjLIwga9We3XZJSAAG7y/0NcFwkuFUm+n6K5vvCJnbjLnm0KcUbF2M3l+RZtEXyz5DPDCVKzd7NdW0AHrGf0Vst23tnx9GIWLuQ5XHtdRVkKORu2V7NTNNV5E0glD3wC8jlUn9iTd1p0yHeY9YkmxLi5bD5CivORG6uHcCnKboXz6RGqpD+fpUMX8gvhY/UhicS+AM2SA== 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=OVVNqNzaEHDE+Jgyw1f0jLhvt6gU9h1CQBbxmnVLoKY=; b=j2s+Zph52YTFdh1vhx/vVyjTAG9uNiKFMwTe/Mr50Ol3HRcOLK7FUHks4Lq8osKkvZkSHYzl9R/eEOKSOK024q/xt+FQuJTDPV6JZFuusvr21ATlDOrUCqo3LJydOCzU4ERo5543j/v2MUlWt+buDI9JBpA4PDPKaKX194KvSqc= Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com (2603:1096:604:bb::12) by OSBPR01MB4504.jpnprd01.prod.outlook.com (2603:1096:604:38::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4823.21; Mon, 27 Dec 2021 13:19:04 +0000 Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::40b5:724c:8c41:b012]) by OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::40b5:724c:8c41:b012%5]) with mapi id 15.20.4823.023; Mon, 27 Dec 2021 13:19:04 +0000 From: "houzj.fnst@fujitsu.com" To: Peter Smith CC: Amit Kapila , Euler Taveira , Greg Nancarrow , vignesh C , Ajin Cherian , "tanghy.fnst@fujitsu.com" , "houzj.fnst@fujitsu.com" , Dilip Kumar , Rahila Syed , Peter Eisentraut , =?utf-8?B?w5ZuZGVyIEthbGFjxLE=?= , japin , Michael Paquier , David Steele , Craig Ringer , Amit Langote , PostgreSQL Hackers Subject: RE: row filtering for logical replication Thread-Topic: row filtering for logical replication Thread-Index: AQHX9jK5fuxjIBD++0mGDYoNk7mJoqw+YgiAgAFeLwCAAAE9AIAGk8gAgAAGVrA= Date: Mon, 27 Dec 2021 13:19:04 +0000 Message-ID: References: In-Reply-To: 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: f260e9a0-ee8a-4d90-381f-08d9c93b744f x-ms-traffictypediagnostic: OSBPR01MB4504:EE_ x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:3968; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: WmEjnesvHNDLA1crrKUvE0agw1DSpsdGsNWFafMa+5v2GBSGTAxNaJc6q7R7yNNyfh5c4khZb/iX2s60I7Y43rQxzP4BBm5aMyOioNV5AlGGwx0LFmirIOk0cTTLQB0vyYa9adIPpwZRB7vm66505gu/1bNy7kTpGGO2x8b+ngdcCmSOqIa8iDycmX8GXz/1oh9s++Q37KJMDaWVlSsL/ZQoQyr+CsrH5gLU2qHAV+TjoWbGuiPyro57chYQmvCN9hkwtqKJiAGTn4gqaSphZp10zpkZU4UpZu7rw/oNGwyFxZASLRMQkzRB4WFGRLLwFzzvowoyxuUtYx8nLkZYdOwOXFrt1Kl/CBd1k/o2NPKv6s04ebGfzsnrmmBQe0DzocUj3XfkoBo+9sL5QVbFBpCYaorfqWXLt9aP0QJi5FbnO5uExqW5MAqyCd7+3b9XwsguVnweCdP5FcmK4uNmrjBlzHbV8gJndGGFowzoIGSi4pJEQOG3NNFu+xw4LERSxdS/nz8IhcQEA/j3mVqa1WZ4Gcelhv+5yBawcD5NQzA41s2I12DdyVUJdQrmb9JmS+3HtTfJm3SPGMyEzur/BhgtkmiUGRnpkegB6B9l+WjA0Cav6mS+D3Tqd1qzNwBE3Ap2p6td01obTkBDb/hAEE++Fx6FpjDyGXxWPK1HrfiZStr3qk0OIE4UIaxOlUqh64lMJZHNgGLJKHfi51QMUg== 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)(8936002)(4744005)(9686003)(122000001)(316002)(508600001)(54906003)(52536014)(86362001)(82960400001)(6506007)(7416002)(53546011)(71200400001)(7696005)(2906002)(2940100002)(8676002)(186003)(66476007)(66556008)(66446008)(55016003)(38070700005)(4326008)(64756008)(26005)(5660300002)(38100700002)(76116006)(66946007)(6916009)(85182001)(33656002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?a1pSMzcxdjNIZk1raUhGUHVFZWZnTldaQ0dUYjIvNFBndUM2endnUW5CL0pw?= =?utf-8?B?M0h2QUIzVUZLVjVocG9FYm4zSWhUeXdsYkJOc1dyck9MUXBXUUEyUkJLN3Nx?= =?utf-8?B?dWhvYWhJeG01Vm1IODh1MkpQeWRmSHMzWm1wOVE1RXNsRVVEVEoyS0RGL2Np?= =?utf-8?B?alpaK2NpVnB1RFFGemowTHp2NnJyQklKellOTXRiNkh6dS9KU1BwMEs1ampL?= =?utf-8?B?b0ZKZFpEdVpXbXd5RitJSUwzaXV3bE1hbFNUYml3VXpaRHVoZjhQRVpIRFI0?= =?utf-8?B?WTA3dFJrSFpwT2s2YWtCT3ZYMDNMRDFYQXF0MWhBaGt6ZlRPOWZreGljWVA4?= =?utf-8?B?WnBEcnd4Z2t0ZVR0bDBGVVVIS3lBTXZQYUp1WVUxUHg5bHZBUXZwN1B3VTNx?= =?utf-8?B?WGE5cEpPNS9PNEVmdHlHUUZ1UWVKTmx5VE15VndNbHdGOWRrS3QvdGs3cnJR?= =?utf-8?B?KzZwek8vTnBqSG1ZYUhGeCsvWnNQKzZQL3dDMDFxR3hVMXRXcjI4OURFQzg1?= =?utf-8?B?akFmMXhPNUY4NVJNYzVmbzV4S1dGRUJJMGhHVm1vd2ZYNkUzUUJZZEdxQWNr?= =?utf-8?B?bVlaUWFKM0F6Z1ZjQXhMdFZLVWNkQ0k4cGVkc3l2R0ZLUWxkbWViTFpaa3RC?= =?utf-8?B?THhkUGRNYWkyTmZRMXh6SUliT0FLeTVWZGFUMWlpWjhvY2RJSUNNd2c2b1J4?= =?utf-8?B?WjZxQ2ZoYll1b0lMM2ZWb1RDMHd3TzdzbEJDUGpLa3NHdEgxMlFKR1psOGlr?= =?utf-8?B?Mkdsa0lzbUF6aE9DZWM5Vm5SSGozUWhUYURXZDV6OFh3T2tucFl4a2VTVXBL?= =?utf-8?B?N1BoOURGdFlQRGZkODZBVU1IakNuQms5dTd0TXBFb2FrWm1oVDhlbjNJN1lu?= =?utf-8?B?L1hJcDkxZG9vemhBQVpJenJUVithOHRKUFlXR3J3U1ptWFRnNm5DY21pN3Uw?= =?utf-8?B?VmNiOENveGVaVUpFVVJUY1YrT1FTWHhVK2hHTWUwbHo3OGdSeVhoNkFNWnB4?= =?utf-8?B?ZWwveDJyU1NqRTgvbkNSUFJYeVpybHlNWURySE92SExiNHpET0pDVGJ4dkwv?= =?utf-8?B?c1VsT1ppQXlBQXJPRC92dDBiVmZyZlNmTGlnS0RENnVnSzhnSHZFY1RVRXNM?= =?utf-8?B?OUw3dExNbHZPZXlWNmNzWUFpMUZmRXJBRXdYNjcrV1V6NzlNcXVPWXU1c1lH?= =?utf-8?B?QWUwU2ZjQVFYRXN6bkFUaCtCQWo5SkRjUDFEMk82ZUVNWVpacWYwN0oyRDIw?= =?utf-8?B?Ym0yRlJZeU9PbXVLNHBHY21lSUJKNTJ0YmNQalovQ2gvT1hJY0tLbU4vdDUw?= =?utf-8?B?cHlteHU2NDdzYnN5dytaZU81dTU3MmZKMkx4VWxYTy9PT0JOQjFXU1lEMlMw?= =?utf-8?B?UkZoOWNiclZJdDdpdDRnZ0pPU2JXNElsNVBINFhKNlI1c2lsWWFDajQ1RTBP?= =?utf-8?B?OXduTjR1ekZ1NGNRZFQybzFMTWFZN0IvaGUwUVJDZ0ROczk0OWIrWitvUzd6?= =?utf-8?B?T21YYVhLMzZjbXlKYkM3MnZxaGxlS2lXdjNtbnRWMUpEY1N2NUdnRWNEczRs?= =?utf-8?B?OEdsTTRYSmh0ZzlBbFFycVRBT2U0RWxiZ0dRTVk5a0FNNjdjQTJVdjZxZnNq?= =?utf-8?B?VGVmblI4SHZCdWFGR0F6b3VvWUNORFc0c2hDUkF2ZU1JWXpwUUxic1dkaERt?= =?utf-8?B?V014MUFjdFZ0eXJQeUpUNGQ5SkNpNjdNZFc4ejJlU29DSzJ3eTFGWWVSL282?= =?utf-8?B?b2hiWis1MG9obEc0YVFZRE0xTEhrbzdIOXlINEVPVS92b2ZjOXFGSEc3aHBL?= =?utf-8?B?N1M3emRkYk90aEQyM082dGlWbVcwVmQxT3FSdVdPYWJ6UFdRNytJa0pVcm54?= =?utf-8?B?S0pNcStGZ0JOdmhYclI5N1ptSkFrMFR4MU1nQys3eXVYajdpbHEvSDJMa1hI?= =?utf-8?B?eit1c3ZNVitBaDBRTXNXaGp5dXhHcFhvaFhvcktyeldNUy9JbVZ0UWJiWUxM?= =?utf-8?B?Yk1tMzM0VUhqc1NnNDdReEw2NWdmWjJabHRzbS9NQW8rc29Pb0N2eUZYNjdw?= =?utf-8?B?cHV1QUNPQjM2bEFReTNiR1pwS1hrL3g3Szg3Kzl6YnkzTGZmdXZIaGJkTGtW?= =?utf-8?B?UmdWalR6c3BJUkduSHRWWDdkZG5pZU9vcEo2cGdwUjQrU1RBVlc4c2VLMll2?= =?utf-8?Q?IXuCIKKElP4N+SBPqRw01Fc=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: f260e9a0-ee8a-4d90-381f-08d9c93b744f X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Dec 2021 13:19:04.0613 (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: CgvkLZWCfnL4IeyEsWsjYnN43UpLmcRpQ+nleyM2nN4AuyMMbiWyvv766f5ZvJ/tEs1gBr1UboRvKpkl/WHTQw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSBPR01MB4504 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gTW9uLCBEZWMgMjcsIDIwMjEgOToxNiBQTSBob3V6ai5mbnN0QGZ1aml0c3UuY29tIDxob3V6 ai5mbnN0QGZ1aml0c3UuY29tPiB3cm90ZToNCj4gT24gVGh1ciwgRGVjIDIzLCAyMDIxIDQ6Mjgg UE0gUGV0ZXIgU21pdGggPHNtaXRocGIyMjUwQGdtYWlsLmNvbT4gd3JvdGU6DQo+ID4gSGVyZSBp cyB0aGUgdjU0KiBwYXRjaCBzZXQ6DQo+IA0KPiBBdHRhY2ggdGhlIHY1NSBwYXRjaCBzZXQgd2hp Y2ggYWRkIHRoZSBmb2xsb3dpbmcgdGVzdGNhc2VzIGluIDAwMDMgcGF0Y2guDQpTb3JyeSBmb3Ig dGhlIHR5cG8gaGVyZSwgSSBtZWFuIHRoZSB0ZXN0cyBhcmUgYWRkZWQgMDAwMiBwYXRjaC4NCg0K QmVzdCByZWdhcmRzLA0KSG91IHpqDQo=