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 1wTGFm-000Pv9-36 for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 09:45:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTGFj-005pFk-2I for pgsql-hackers@arkaria.postgresql.org; Sat, 30 May 2026 09:45:12 +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 1wTGFj-005pFY-1L for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 09:45:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wTGFh-00000000Hwv-0hDQ for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 09:45:10 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wTGFd-000nLc-1j for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 09:45:06 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTGFd-000epq-2d for pgsql-hackers@lists.postgresql.org; Sat, 30 May 2026 09:45:05 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: RFC: Allow EXPLAIN to Output Page Fault Information To: pgsql-hackers@lists.postgresql.org From: Ilmar Y Cc: Atsushi Torikoshi Date: Sat, 30 May 2026 09:44:08 +0000 User-Agent: pgcommitfest X-cfsender: tanswis42.gmail.com In-Reply-To: References: Message-ID: <178013424821.1017.15729495841275970312.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIHRlc3RlZCwgZmFpbGVkClNwZWMgY29tcGxpYW50OiAgICAg ICAgICAgbm90IHRlc3RlZApEb2N1bWVudGF0aW9uOiAgICAgICAgICAgIG5vdCB0ZXN0ZWQKCkhp LA0KDQpJIGxvb2tlZCBhdCB2MTEsIGZvY3VzaW5nIG9uIHN0cnVjdHVyZWQgRVhQTEFJTiBvdXRw dXQgYW5kIGEgc21hbGwgbG9jYWwNCmJ1aWxkL3Rlc3QgcGFzcy4NCg0KVGhlIHBhdGNoIGFwcGxp ZXMgY2xlYW5seSBvbiBjdXJyZW50IG1hc3RlciBhdA0KZGI1ZWQwMzIxN2I5YzIzODcwM2RmOGI0 YjI4NjExNWQ2ZTk0MDQ4OCwgYnV0IGdpdCBhbSB3YXJuZWQgYWJvdXQgdHJhaWxpbmcNCndoaXRl c3BhY2UuICBnaXQgZGlmZiAtLWNoZWNrIG9yaWdpbi9tYXN0ZXIuLi5IRUFEIHJlcG9ydHM6DQoN CnNyYy90ZXN0L21vZHVsZXMvdGVzdF9taXNjL3QvMDExX2V4cGxhaW5fc3RvcmFnZV9pby5wbDo0 NzogdHJhaWxpbmcgd2hpdGVzcGFjZQ0Kc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X21pc2MvdC8wMTFf ZXhwbGFpbl9zdG9yYWdlX2lvLnBsOjU1OiB0cmFpbGluZyB3aGl0ZXNwYWNlDQpzcmMvdGVzdC9t b2R1bGVzL3Rlc3RfbWlzYy90LzAxMV9leHBsYWluX3N0b3JhZ2VfaW8ucGw6NjE6IHRyYWlsaW5n IHdoaXRlc3BhY2UNCg0KQSBzZWNvbmQgdGhpbmcgSSBub3RpY2VkIGlzIHRoYXQsIHdpdGggaW9f bWV0aG9kPXN5bmMsIHN0cnVjdHVyZWQgRVhQTEFJTg0Kb3V0cHV0IGNhbiBzaG93IGFuIEV4ZWN1 dGlvbiBTdG9yYWdlIEkvTyBzZWN0aW9uIGV2ZW4gd2hlbiBBTkFMWVpFIGlzIG5vdA0KdXNlZC4N Cg0KRm9yIGV4YW1wbGU6DQoNCkNSRUFURSBUQUJMRSB0IEFTIFNFTEVDVCBnZW5lcmF0ZV9zZXJp ZXMoMSwgMykgQVMgYTsNCkVYUExBSU4gKEJVRkZFUlMsIEZPUk1BVCBKU09OKSBTRUxFQ1QgKiBG Uk9NIHQ7DQoNCnJldHVybnMsIGluIHBhcnQ6DQoNCiAgICAiUGxhbm5pbmciOiB7DQogICAgICAu Li4NCiAgICAgICJTdG9yYWdlIEkvTyBSZWFkIjogMCwNCiAgICAgICJTdG9yYWdlIEkvTyBXcml0 ZSI6IDANCiAgICB9LA0KICAgICJFeGVjdXRpb24iOiB7DQogICAgICAiU3RvcmFnZSBJL08gUmVh ZCI6IDAsDQogICAgICAiU3RvcmFnZSBJL08gV3JpdGUiOiAwDQogICAgfQ0KDQpUaGUgc2FtZSBo YXBwZW5zIHdpdGggRk9STUFUIFhNTCBhbmQgRk9STUFUIFlBTUwuICBUaGUgcXVlcnkgd2FzIG5v dA0KZXhlY3V0ZWQsIHNvIEkgZG9uJ3QgdGhpbmsgYW4gRXhlY3V0aW9uIHNlY3Rpb24gc2hvdWxk IGJlIGVtaXR0ZWQgaGVyZS4NCg0KVGhlIGV4aXN0aW5nIEJVRkZFUlMgZG9jdW1lbnRhdGlvbiBz YXlzIHRoYXQgd2hlbiBCVUZGRVJTIGlzIHRydWUgd2l0aG91dA0KQU5BTFlaRSwgb25seSBidWZm ZXIgdXNhZ2UgZHVyaW5nIHF1ZXJ5IHBsYW5uaW5nIGlzIHJlcG9ydGVkLiAgU2luY2UgdGhpcw0K b3V0cHV0IGlzIHVuZGVyIEJVRkZFUlMsIGFuIEV4ZWN1dGlvbiBTdG9yYWdlIEkvTyBzZWN0aW9u IHdpdGhvdXQgQU5BTFlaRQ0KbG9va3Mgc3VycHJpc2luZyB0byBtZS4NCg0KRm9yIGNvbXBhcmlz b24sIHRleHQgb3V0cHV0IGZvciB0aGUgc2FtZSBxdWVyeSByZXBvcnRzIG9ubHkgdGhlIFBsYW5u aW5nDQpzZWN0aW9uIGFuZCBoYXMgbm8gRXhlY3V0aW9uIHNlY3Rpb246DQoNClBsYW5uaW5nOg0K ICBCdWZmZXJzOiBzaGFyZWQgaGl0PTEyIHJlYWQ9Nw0KDQpJdCBsb29rcyBsaWtlIHRoaXMgY29t ZXMgZnJvbSBFeHBsYWluT25lUGxhbigpIGNvbnNpZGVyaW5nIGV4ZWN1dGlvbiBTdG9yYWdlDQpJ L08gd2hlbmV2ZXIgZXMtPmJ1ZmZlcnMgaXMgdHJ1ZSwgYW5kIHBlZWtfc3RvcmFnZWlvX3VzYWdl KCkgcmV0dXJuaW5nIHRydWUNCmZvciBub24tdGV4dCBmb3JtYXRzIGV2ZW4gd2hlbiBib3RoIGNv dW50ZXJzIGFyZSB6ZXJvLiAgU2hvdWxkIHRoZSBleGVjdXRpb24NClN0b3JhZ2UgSS9PIHNlY3Rp b24gYmUgZ2F0ZWQgb24gZXMtPmFuYWx5emUsIHNpbWlsYXIgdG8gRXhlY3V0aW9uIFRpbWU/DQoN CkxvY2FsIGNoZWNrcyBJIHJhbjoNCg0KZ2l0IGRpZmYgLS1jaGVjayBvcmlnaW4vbWFzdGVyLi4u SEVBRDogZmFpbGVkIHdpdGggdGhlIHdoaXRlc3BhY2UgaXNzdWUgYWJvdmUNCi4vY29uZmlndXJl IC0tcHJlZml4PSIkUFdEL3BnLWluc3RhbGwiIC0td2l0aG91dC1yZWFkbGluZSAtLXdpdGhvdXQt emxpYiAtLXdpdGhvdXQtaWN1OiBwYXNzZWQNCm1ha2UgLXMgLWo4OiBwYXNzZWQNCm1ha2UgLXMg aW5zdGFsbDogcGFzc2VkDQptYWtlIC1DIHNyYy90ZXN0L3JlZ3Jlc3MgY2hlY2sgVEVTVFM9ZXhw bGFpbjogcGFzc2VkDQoNCkkgdHJpZWQgdG8gcnVuIHRoZSBuZXcgVEFQIHRlc3QsIGJ1dCB0aGlz IGxvY2FsIGVudmlyb25tZW50IGlzIG1pc3NpbmcgdGhlDQpJUEM6OlJ1biBQZXJsIG1vZHVsZSBy ZXF1aXJlZCBieSAtLWVuYWJsZS10YXAtdGVzdHMsIHNvIEkgY291bGQgbm90IHZlcmlmeSBpdA0K bG9jYWxseS4NCg0KSSBjb3VsZCBub3QgdGVzdCBMaW51eCBpb191cmluZyBiZWhhdmlvciBpbiB0 aGlzIGxvY2FsIG1hY09TIGVudmlyb25tZW50LCBhbmQNCkkgaGF2ZSBub3QgYmVuY2htYXJrZWQg dGhlIGdldHJ1c2FnZSgpIG92ZXJoZWFkLg0KDQpSZWdhcmRzLA0KSWxtYXIgWXVudXNvdgoKVGhl IG5ldyBzdGF0dXMgb2YgdGhpcyBwYXRjaCBpczogV2FpdGluZyBvbiBBdXRob3IK