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 1wDgCX-003Ege-39 for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 10:13:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wDgCX-009QEB-0G for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2026 10:13:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wDgCW-009QE3-29 for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2026 10:13:28 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wDgCT-00000001ddT-2XZN for pgsql-hackers@postgresql.org; Fri, 17 Apr 2026 10:13:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=foX+NnSX9gpmRe9BP/1q9Qc1qK0KmPH0bUPOn+8BOsQ=; b=uYcWhBspkLZFRLRz2qrCNEQ0mi xyI2UBRO9z+ASTRFpSWEtKTNepkNv3K2JxDt4WVE92k7f2JHEOo/MfLBvvzlpBeNidUHr2z8yvmJA G7RJ2NtT99ABVSmzZ910XDnuM7S655aDXkfDaZ/VcnYgCJiblt+K8glDu1Lf5dMZZHHO45s9vcIzK YR3JQywwaCGXf2wwrLKemoco84V9f6wV2oW/NkQRnxCbE2kbAMPz1fdCDwJ5rKzexEwuUYlBUAH/E a80qPmr6FSzr8Z8XsYRETdAI/ItmXIQ7TPo36FzMHe4dWR7mNRgeqENkIUCmFjwBGRrP/irDDSYg8 ya+XsnuQ==; Received: from [2409:11:4120:300:550a:addb:33eb:3166] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wDgCL-0040Yf-2S; Fri, 17 Apr 2026 10:13:20 +0000 Date: Fri, 17 Apr 2026 19:13:03 +0900 (JST) Message-Id: <20260417.191303.359804214243525887.ishii@postgresql.org> To: assam258@gmail.com Cc: zsolt.parragi@percona.com, sjjang112233@gmail.com, vik@postgresfriends.org, er@xs4all.nl, jacob.champion@enterprisedb.com, david.g.johnston@gmail.com, peter@eisentraut.org, pgsql-hackers@postgresql.org Subject: Re: Row pattern recognition From: Tatsuo Ishii In-Reply-To: <20260417.171022.397021509290810631.ishii@postgresql.org> References: <20260410.183515.1561517749674643173.ishii@postgresql.org> <20260417.171022.397021509290810631.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-7 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:550a:addb:33eb:3166 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgSGVuc29uLA0KDQpOb3RlIHRoYXQgYXBwbHlpbmcgMDAwMS0wMDA2IHByb2R1Y2VkIGNvbXBp bGVyIHdhcm5pbmcuDQoNCmV4ZWNFeHBySW50ZXJwLmM6IEluIGZ1bmN0aW9uIKFFeGVjRXZhbFJQ Uk5hdlNldKI6DQpleGVjRXhwckludGVycC5jOjYwMDU6MjM6IHdhcm5pbmc6IKF0YXJnZXRfcG9z oiBtYXkgYmUgdXNlZCB1bmluaXRpYWxpemVkIFstV21heWJlLXVuaW5pdGlhbGl6ZWRdDQogNjAw NSB8ICAgICAgICAgdGFyZ2V0X3Nsb3QgPSBFeGVjUlBSTmF2R2V0U2xvdCh3aW5zdGF0ZSwgdGFy Z2V0X3Bvcyk7DQogICAgICB8ICAgICAgICAgICAgICAgICAgICAgICBefn5+fn5+fn5+fn5+fn5+ fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn4NCmV4ZWNFeHBySW50ZXJwLmM6NTk1OToyNTogbm90ZTog oXRhcmdldF9wb3OiIHdhcyBkZWNsYXJlZCBoZXJlDQogNTk1OSB8ICAgICAgICAgaW50NjQgICAg ICAgICAgIHRhcmdldF9wb3M7DQogICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgIF5+fn5+ fn5+fn4NCg0KQnV0IHJlZ3Jlc3Npb24gdGVzdCB3YXMgb2suDQpIb3dldmVyLCBhZnRlciBhcHBs eWluZyAwMDA3LCByZWdyZXNzaW9uIHRlc3QgZmFpbGVkLg0KDQpub3Qgb2sgMTk2ICAgKyBycHJf aW50ZWdyYXRpb24gICAgICAgICAgICAgICAgICAgICAgICAgICA1MTQgbXMNCiMgKHRlc3QgcHJv Y2VzcyBleGl0ZWQgd2l0aCBleGl0IGNvZGUgMikNCiMgcGFyYWxsZWwgZ3JvdXAgKDkgdGVzdHMp OiAganNvbnBhdGgganNvbnBhdGhfZW5jb2RpbmcganNvbmJfanNvbnBhdGggc3FsanNvbl9xdWVy eWZ1bmNzIGpzb25fZW5jb2RpbmcganNvbiBzcWxqc29uX2pzb250YWJsZSBqc29uYiBzcWxqc29u DQpub3Qgb2sgMTk3ICAgKyBqc29uICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgMjkgbXMNCiMgKHRlc3QgcHJvY2VzcyBleGl0ZWQgd2l0aCBleGl0IGNvZGUgMikNCm5vdCBv ayAxOTggICArIGpzb25iICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAyOSBt cw0KIyAodGVzdCBwcm9jZXNzIGV4aXRlZCB3aXRoIGV4aXQgY29kZSAyKQ0KW3NuaXBdDQoNCkZy b20gcnByX2ludGVncmF0aW9uLm91dDoNCg0KLS0gVmVyaWZ5IGJvdGggcHJvZHVjZSBkaWZmZXJl bnQgcmVzdWx0cw0KU0VMRUNUDQogICAgaWQsIHZhbCwNCiAgICBjb3VudCgqKSBPVkVSIHdfcnBy IEFTIHJwcl9jbnQsDQogICAgY291bnQoKikgT1ZFUiB3X25vcm1hbCBBUyBub3JtYWxfY250DQpG Uk9NIHJwcl9pbnRlZw0KV0lORE9XDQogICAgd19ycHIgQVMgKE9SREVSIEJZIGlkDQogICAgICAg IFJPV1MgQkVUV0VFTiBDVVJSRU5UIFJPVyBBTkQgVU5CT1VOREVEIEZPTExPV0lORw0KICAgICAg ICBQQVRURVJOIChBIEIrKQ0KICAgICAgICBERUZJTkUgQiBBUyB2YWwgPiBQUkVWKHZhbCkpLA0K ICAgIHdfbm9ybWFsIEFTIChPUkRFUiBCWSBpZA0KICAgICAgICBST1dTIEJFVFdFRU4gQ1VSUkVO VCBST1cgQU5EIFVOQk9VTkRFRCBGT0xMT1dJTkcpDQpPUkRFUiBCWSBpZDsNCnNlcnZlciBjbG9z ZWQgdGhlIGNvbm5lY3Rpb24gdW5leHBlY3RlZGx5DQoJVGhpcyBwcm9iYWJseSBtZWFucyB0aGUg c2VydmVyIHRlcm1pbmF0ZWQgYWJub3JtYWxseQ0KCWJlZm9yZSBvciB3aGlsZSBwcm9jZXNzaW5n IHRoZSByZXF1ZXN0Lg0KY29ubmVjdGlvbiB0byBzZXJ2ZXIgd2FzIGxvc3QNCg0KUmVnYXJkcywN Ci0tDQpUYXRzdW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFv c3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0K