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 1wVEML-001nwq-2K for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 20:08:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wVELL-008PuV-1L for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 20:07:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wVELL-008PuN-0P for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 20:07:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wVELJ-000000017le-1ss0 for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 20:07:06 +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 1wVELI-003QcG-2n for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 20:07:04 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wVELI-002bty-10 for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 20:07:04 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block To: pgsql-hackers@lists.postgresql.org From: Ethan Mertz Cc: SATYANARAYANA NARLAPURAM Date: Thu, 04 Jun 2026 20:07:00 +0000 User-Agent: pgcommitfest X-cfsender: ethanmertz In-Reply-To: References: Message-ID: <178060362097.594057.16093365170628444552.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIHRlc3RlZCwgcGFzc2VkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgdGVzdGVk LCBwYXNzZWQKCkhpIFNhdHlhLA0KDQpJIHJldmlld2VkIHRoZSB2MiBwYXRjaCAoMDAwMS14bG9n cHJlZmV0Y2hlci1yZWNvcmQtRlBXLVdJTExfSU5JVC0uLi4pLg0KDQpBcHBsaWVkIGNsZWFubHkg dG8gY3VycmVudCBIRUFELCBidWlsdCB3aXRoIC0tZW5hYmxlLWNhc3NlcnQgYW5kDQotLWVuYWJs ZS1kZWJ1ZywgbWFrZSBjaGVjayBhbmQgbWFrZSBpbnN0YWxsY2hlY2sgcGFzcy4NCg0KPiBGaXhl ZCB0aGlzIGJ5IG1ha2luZyB0aGVzZSBibG9ja3MgYXMgcmVjZW50bHkgc2VlbiBpbiB0aGUgRlBX IGFuZCBXSUxMX0lOSVQNCj4gc2tpcCBwYXRocy4gVGhlIGV4aXN0aW5nIGR1cGxpY2F0ZS1jaGVj ayBsb29wIHRoZW4gbmF0dXJhbGx5IHN1cHByZXNzZXMNCj4gcHJlZmV0Y2ggYXR0ZW1wdHMgZm9y IHN1YnNlcXVlbnQgcmVmZXJlbmNlcyB0byB0aGUgc2FtZSBibG9jaywgY291bnRpbmcNCj4gdGhl bSB1bmRlciB0aGUgc2tpcF9yZXAgc3RhdC4NCg0KVGhlIGFwcHJvYWNoIGludGVncmF0ZXMgY2xl YW5seSBpbnRvIHRoZSBleGlzdGluZyBwcmVmZXRjaCBpbmZyYXN0cnVjdHVyZQ0KcmV1c2luZyB0 aGUgcmVjZW50bHktc2VlbiB3aW5kb3cgZm9yIGRlZHVwbGljYXRpb24gcmF0aGVyIHRoYW4gYWRk aW5nIG5ldw0KdHJhY2tpbmcgc3RhdGUgaXMgYSBuaWNlIGRlc2lnbiBjaG9pY2UuDQoNCkkgYWxz byBhZ3JlZSB3aXRoIHRoZSBjaG9pY2UgdG8gYWRkIHRoaXMgbG9naWMgdG8gaW5pdCBhbmQgZnB3 IHJlY29yZHMgYnV0IG5vdCB0aGUNCmZpbHRlcmVkIHBhZ2VzIGJlY2F1c2UgdGhlc2UgbWF5IHN0 aWxsIGJlIGJlbmVmaWNpYWwgdG8gcmVhZCBsYXRlciBpbiB0aGUgd2luZG93Lg0KDQpJIHJlYWQg dGhyb3VnaCB0aGUgY29kZSBhbmQgaXQgbG9va3MgY29ycmVjdCB0byBtZS4gT25lIG1pbm9yIG5p dDogdGhlcmUncw0KYW4gZXh0cmEgYmxhbmsgbGluZSBhZGRlZCBqdXN0IGJlZm9yZSBscnFfY29t cGxldGVfbHNuIHRoYXQgc2VlbXMgdW5yZWxhdGVkDQp0byB0aGUgY2hhbmdlLiBSZW1vdmluZyB0 aGlzIHdvdWxkIGtlZXAgdGhlIGRpZmYgZm9jdXNlZC4NCg0KSSdtIG1hcmtpbmcgdGhpcyBSZWFk eSBmb3IgQ29tbWl0dGVyLg0KDQpCZXN0LA0KRXRoYW4gTWVydHoNClNERSwgQW1hem9uIFdlYiBT ZXJ2aWNlcwoKVGhlIG5ldyBzdGF0dXMgb2YgdGhpcyBwYXRjaCBpczogUmVhZHkgZm9yIENvbW1p dHRlcgo=