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 1vrRVK-0046pE-2I for pgsql-hackers@arkaria.postgresql.org; Sun, 15 Feb 2026 02:04:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrRVI-000gJt-0B for pgsql-hackers@arkaria.postgresql.org; Sun, 15 Feb 2026 02:04:56 +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 1vrRVH-000gJk-1h for pgsql-hackers@lists.postgresql.org; Sun, 15 Feb 2026 02:04:55 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vrRVE-00000000foh-0UqW for pgsql-hackers@lists.postgresql.org; Sun, 15 Feb 2026 02:04:54 +0000 Received: by mail-wr1-x435.google.com with SMTP id ffacd0b85a97d-4358fb60802so1469913f8f.1 for ; Sat, 14 Feb 2026 18:04:52 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771121090; cv=none; d=google.com; s=arc-20240605; b=S8dyywIEC2Qk0NE3ZiDhcL5PEL1751Np6rh9ifJXn8DCgMuAHM+I1jbzT/TaUBDFu3 d5x+WD7Po8jZDA+Q+y2OX2NE8nnLIOO3K/56OkLYVWjWIa0TE4Dz5W2swweMSarWCxM7 BT/gubOZo2LZMqOGcG/FyrLq/5+QY1EE5AdxDBzJvcjp7q7ZDhpf7pkYzTRZEb/8obBD D3PkbOnUXORb6bmYGiGlbQGQUUhcualSwCp1tlmYDXvIPUKM3GWiHBEaPUd14cK8uFTT 3ylx7Unke6jqy8KFCFoBYG1Lf1GfmXnIxxisPXQP8oaeTwmERoEmnOOWlJXFnW5SBXFz PypQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=xqbhDHIuJxEYxZkG0kTgdpvibCEVdyHimzLqJfQWvO0=; fh=t9n6gcIOQYq3th8UazWiPCOXqqK1TDw5HujZkFPmvkQ=; b=EHJIpV4PwZRgISyZLd0bT5I5EuJZe2xS/I7XFefV2MdHhYNgD6DfCUzw3sAr0qdwEQ a+75EhtU00S+NhH7w/Huh3/ywj6KinHzzYXKYgEYGu9E/dv1J2Qk1Pvd1Pq5eL9gxiEg 9lixv/eVFHNMUlqk7P1ZLrwfjviLNxBOXGIPW8jRhNP2zPjvg3wSCxW4ABxvtq6/R4dl /FjUgpddphuh26KvusYkX+UMuNnYHbyUx8lNs2LqAt8WSB/MPInDsNTQ7IsMcM4pCTXW nhw6tYXyWytj0a1tVPGTH3JqpO2SYYQ4D+wY9uc2S+NKTAlWBxAkdfHQbruDOcMTX0MP 5rjQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bowt-ie.20230601.gappssmtp.com; s=20230601; t=1771121090; x=1771725890; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=xqbhDHIuJxEYxZkG0kTgdpvibCEVdyHimzLqJfQWvO0=; b=B+vqLBaXrM+yeGmbe3SPlhNq/GGEvmkyE71tdofCS0pSmQoRbGGjHy4JKGmgkNo6QG l3txKGkcYjsYL0RUvvcxIl0igkMyYPIu/wiXswTaRkpB86Q6/EscvX6b3xeztRJjjPeG BRE5sOTy3RarrJcYi/wC22avKUaGH7MJqxj5eCGP/ffgOTnXXV8ahCTT4YMOI4Cg9hrQ kyghsf+T6pD6WWIiJZpsDj6/hx/9LtpbqHwGgabArhlFkKbwML2Go4U7chTIHOeWuzTY +gkFZ5R4aRpo5x5336R4YTqDYysD2Qz+PmKwLesdmYqLKXbaK2x+4PvcD/4EIXPldD2h SQAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771121090; x=1771725890; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=xqbhDHIuJxEYxZkG0kTgdpvibCEVdyHimzLqJfQWvO0=; b=cyST4fhwpRxm4oxXcXLtb5VHr+rNde8rGFbfdV2fnsPtEN/HsRZv011EmXm15U8tB+ GMZ4dx4brdGBFBTPk5SKjf24rWxYGikrTKGTDB53fs8XEUPDWfRc+LCoQYGj05cCP70O S69WyTF8rufW1ew1Mt1iopGs9SQSu1t/zhBpNzMKxHenpHoW/Bg3e1IJInM8IIzm1BGy AqvHdbl9BFHIpE9l9ZFetI8dwt9QggSFH6is+Etk28lE44U8l6klvUcdbtFNXqHDSvfZ SoYXb0QwV6Q1zgplEkHzU6L5Od9UP3W8gfFzlEZQD3WCG1fFriI/qhTz2M9sb2kcXWY0 6pSA== X-Forwarded-Encrypted: i=1; AJvYcCUXi7o9KXVr8oDvKzNLoRTHg1MA9occU0ER2FEkRQ/sN76QMXlK4szKaDOkhk9HlPNbKzpp+hLM9OO7B/0H@lists.postgresql.org X-Gm-Message-State: AOJu0Yx7dU5bg7fT06uz7ISJtvhA9hF1VfIGV+8v0pthJeh9AQU07Fcx L/b9c96u9DrSEkDxq7uGdY68blioAiJbZT6u2lpQyU6pvtRIoRZEm/A3Qg9plh2ul0I6LgRsOOr KFyIeXFTw/k/NJ8FQjSo1xMIiznucTKFhTxAcDX0Naw== X-Gm-Gg: AZuq6aLz21ccdStzyYAjtDUx8dNTXSsy3Zey1RTcPkY5V56wlswsLg3KLSqXsX4CO3n mPLa1ig5ax/M7woh6L1J/1IiCcTKIyfGDEcJsc7WYx45bebQ6u/qqMAj6F8bAJPKDoCUpjm0eB7 Vvz0gE/alZoXcVwdgdRTQaI2VQG98vinIdDz41GYePzMqoKEqog1S6/1FCCFTOhRRphB/yV/Yhf 7AuxcRwUsuau+9A1uElcWdAhAzwAKuw6jv6fsc47RACXpYbYjr4GRS08ha9Li8TSQ6j3exrLCO3 YHByKjo= X-Received: by 2002:a05:6000:2dc2:b0:435:9538:939b with SMTP id ffacd0b85a97d-4379d5e3c64mr8241828f8f.8.1771121089510; Sat, 14 Feb 2026 18:04:49 -0800 (PST) MIME-Version: 1.0 References: <6d59c277-c440-4d1f-a46e-157958c06a5f@vondra.me> <5pltwb73d7cynsxo2yb54ygjk7haviatkrx43mnzihc6kkield@ahnstpgof46i> <931afce3-8c86-4c96-9861-0ffa17c6560f@vondra.me> <4zeu5yb73byiquvf3eefsunnrydyqfxy3eup66jrliutrtd4xl@5iifjey4n5m5> In-Reply-To: From: Peter Geoghegan Date: Sat, 14 Feb 2026 21:04:22 -0500 X-Gm-Features: AaiRm52U6hwbxm85u3cxSaU38yM-UUUpwog8RYIxlyYoHBP0y5IPJykHEaQO5Qw Message-ID: Subject: Re: index prefetching To: Alexandre Felipe Cc: Tomas Vondra , Andres Freund , Thomas Munro , Nazir Bilal Yavuz , Robert Haas , Melanie Plageman , PostgreSQL Hackers , Georgios , Konstantin Knizhnik , Dilip Kumar Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0LCBGZWIgMTQsIDIwMjYgYXQgNzoxM+KAr1BNIEFsZXhhbmRyZSBGZWxpcGUNCjxvLmFs ZXhhbmRyZS5mZWxpcGVAZ21haWwuY29tPiB3cm90ZToNCj4gRm9yIHRoZSB0ZXN0cywgSSBkaXNh YmxlIHNvcnRpbmcsIHNlcXVlbnRpYWwgc2NhbnMsIGluZGV4IG9ubHkgc2NhbnMgYW5kIGJpdG1h cCBzY2Fucy4NCj4gU2luY2UgYnVmZmVyIGNhY2hlIGFsd2F5cyBoYXMgYSBzaWduaWZpY2FudCBp bXBhY3Qgb24gdGhlIHF1ZXJ5IHBlcmZvcm1hbmNlLCBJIHNodWZmbGVkIHRoZSB0ZXN0cywgYW5k IHRyaWVkIHRvIGFkanVzdCBmb3IgdGhlIG51bWJlciBvZiBidWZmZXIgaGl0L3JlYWQsIGJ1dCBs YXRlciBJIGZvdW5kIHRoYXQgdGhlIGJlc3Qgd2F5IHRvIGNvbnRyb2wgdGhhdCB3YXMgdG8gdXNl IGEgdGFibGUgc21hbGwgZW5vdWdoIHRvIGJlIGVudGlyZWx5IGhlbGQgaW4gY2FjaGUsIGFuZCBl dmljdCB0aGUgYnVmZmVycy4NCg0KSG93IGRpZCB5b3UgYWNjb3VudCBmb3IgdGhlIE9TIGZpbGVz eXN0ZW0gY2FjaGU/IEl0IGxvb2tzIGxpa2UgeW91DQpkaWRuJ3QsIGJhc2VkIG9uIHRoaXMgcnVu X2JlbmNobWFya3Muc2ggY29kZToNCg0KPiBkcm9wX2NhY2hlcygpIHsNCj4gICAgZWNobyAiU2tp cCBkcm9wcGluZyBPUyBjYWNoZXMgKHJlcXVpcmVzIHN1ZG8pLi4uIg0KPiB9DQoNCkkgcmFuIHlv dXIgYmVuY2htYXJrIHRlc3RfcHJlZmV0Y2hfcmVncmVzc2lvbnMuc3FsLCB1c2luZyAicHNxbCAt Zg0KdGVzdF9wcmVmZXRjaF9yZWdyZXNzaW9ucy5zcWwiLiBBZ2FpbnN0IG15IHdvcmtpbmcgY29w eSBvZiB0aGUgcGF0Y2gsDQp0aGlzIHByb2NlZHVyZSBnYXZlIG1lIHRoZXNlIHJlc3VsdHM6DQoN CuKUjOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUrOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUrOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUrOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUrOKUgOKUgOKU gOKUgOKUrOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUrOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU rOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUkA0K4pSCIGNvbHVtbl9uYW1lIOKUgiBpb19tZXRo b2Qg4pSCIG51bV93b3JrZXJzIOKUgiBldmljdF9tb2RlIOKUgiBuICDilIIgT0ZGX21zIOKUgg0K T05fbXMg4pSCIGVmZmVjdCDilIINCuKUnOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUpA0K4pSCIHBl cmlvZGljICAgIOKUgiBpb191cmluZyAg4pSCICAgICAgICAgICAwIOKUgiBvZmYgICAgICAgIOKU giAyMCDilIIgIDc2LjU5IOKUgg0KNzcuMTEg4pSCICAwLjAwMyDilIINCuKUgiBwZXJpb2RpYyAg ICDilIIgaW9fdXJpbmcgIOKUgiAgICAgICAgICAgMCDilIIgcGcgICAgICAgICDilIIgMjAg4pSC ICA4Ny4yMiDilIINCjg5Ljc3IOKUgiAgMC4wMTQg4pSCDQrilIIgcGVyaW9kaWMgICAg4pSCIGlv X3VyaW5nICDilIIgICAgICAgICAgIDIg4pSCIG9mZiAgICAgICAg4pSCIDIwIOKUgiAgNzYuNDYg 4pSCDQo3Ny45NCDilIIgIDAuMDEwIOKUgg0K4pSCIHBlcmlvZGljICAgIOKUgiBpb191cmluZyAg 4pSCICAgICAgICAgICAyIOKUgiBwZyAgICAgICAgIOKUgiAyMCDilIIgIDg3LjQyIOKUgg0KODku NjQg4pSCICAwLjAxMyDilIINCuKUgiByYW5kb20gICAgICDilIIgaW9fdXJpbmcgIOKUgiAgICAg ICAgICAgMCDilIIgb2ZmICAgICAgICDilIIgMjAg4pSCICA3Ny43NiDilIINCjc4LjMyIOKUgiAg MC4wMDQg4pSCDQrilIIgcmFuZG9tICAgICAg4pSCIGlvX3VyaW5nICDilIIgICAgICAgICAgIDAg 4pSCIHBnICAgICAgICAg4pSCIDIwIOKUgiAgODcuNjYg4pSCDQo5MS41MiDilIIgIDAuMDIyIOKU gg0K4pSCIHJhbmRvbSAgICAgIOKUgiBpb191cmluZyAg4pSCICAgICAgICAgICAyIOKUgiBvZmYg ICAgICAgIOKUgiAyMCDilIIgIDc3LjU5IOKUgg0KNzguNTcg4pSCICAwLjAwNiDilIINCuKUgiBy YW5kb20gICAgICDilIIgaW9fdXJpbmcgIOKUgiAgICAgICAgICAgMiDilIIgcGcgICAgICAgICDi lIIgMjAg4pSCICA4Ny44NSDilIINCjkxLjE5IOKUgiAgMC4wMTkg4pSCDQrilIIgc2VxdWVudGlh bCAg4pSCIGlvX3VyaW5nICDilIIgICAgICAgICAgIDAg4pSCIG9mZiAgICAgICAg4pSCIDIwIOKU giAgNjQuMTgg4pSCDQo2NC42NCDilIIgIDAuMDA0IOKUgg0K4pSCIHNlcXVlbnRpYWwgIOKUgiBp b191cmluZyAg4pSCICAgICAgICAgICAwIOKUgiBwZyAgICAgICAgIOKUgiAyMCDilIIgIDczLjA0 IOKUgg0KNjkuMjQg4pSCIC0wLjAyNyDilIINCuKUgiBzZXF1ZW50aWFsICDilIIgaW9fdXJpbmcg IOKUgiAgICAgICAgICAgMiDilIIgb2ZmICAgICAgICDilIIgMjAg4pSCICA2NC4xNiDilIINCjY0 LjM2IOKUgiAgMC4wMDIg4pSCDQrilIIgc2VxdWVudGlhbCAg4pSCIGlvX3VyaW5nICDilIIgICAg ICAgICAgIDIg4pSCIHBnICAgICAgICAg4pSCIDIwIOKUgiAgNzMuMDUg4pSCDQo2OS4xNiDilIIg LTAuMDI3IOKUgg0K4pSU4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS0 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pS04pSA4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSYDQooMTIgcm93cykNCg0KVGhl ICJlZmZlY3QiIHNob3duIG9uIG15IExpbnV4IHdvcmtzdGF0aW9uIGp1c3QgbG9va3MgbGlrZSBy YW5kb20NCm5vaXNlIChJIGFsc28gdGVzdGVkICJ3b3JrZXIiLCB3aXRoIHNpbWlsYXIgcmVzdWx0 cykuIGlvc3RhdCBzZWVtcyB0bw0Kc2hvdyBqdXN0IGFib3V0IG5vIEkvTyBvbiBteSBzeXN0ZW0g d2hlbiBwc3FsIHJ1bnMuIEkgY2VydGFpbmx5IGRpZG4ndA0KZG8gYW55dGhpbmcgdG8gZHJvcCB0 aGUgT1MgZmlsZXN5c3RlbSBjYWNoZSBoZXJlLCBzbyB0aGlzIGlzbid0DQpzdXJwcmlzaW5nLg0K DQpIb3cgc2hvdWxkIEkgZ28gYWJvdXQgcmVjcmVhdGluZyB5b3VyIHJlc3VsdD8gVGhpcyB3YXMg bXkgYmVzdCBndWVzcw0KYXQgaG93IHRvIGRvIHNvLiBCdXQgaXQgZG9lc24ndCBmZWVsIGxpa2Ug YSBnb29kIGd1ZXNzLg0KDQo+IFJ1bm5pbmcgZnJvbSBweXRob24gd2l0aCBwc3ljb3BnDQo+DQo+ IFNVTU1BUlkNCg0KQXJlIHRoZSBudW1iZXJzIHlvdSBzaG93ZWQgY29tcGFyaW5nIHRoZSBwYXRj aCB0byB0aGUgbWFzdGVyIGJyYW5jaD8NCk9yIGlzIGl0IGp1c3QgY29tcGFyaW5nIGVuYWJsZV9p bmRleHNjYW5fcHJlZmV0Y2g9b24gdG8NCmVuYWJsZV9pbmRleHNjYW5fcHJlZmV0Y2g9b2ZmIHdp dGggdGhlIHBhdGNoPw0KDQpEaWQgeW91IHdyaXRlIGFsbCB0aGlzIHRlc3QgY29kZSB5b3Vyc2Vs Zj8NCg0KPiBJIGNvdWxkIG5vdCBzZWUgdGhlIGV4cGVjdGVkIHBvc2l0aXZlIGltcGFjdCBhbmQg d2hlbiB1c2luZyB0aGUgcHl0aG9uIHNjcmlwdCBhbmQgYnVmZmVycyBldmljdGVkIHByZWZldGNo IGhhZCBhIGRldHJpbWVudGFsIGltcGFjdC4NCg0KV2hhdCBleHBlY3RlZCBiZW5lZml0Pw0KDQpU aGUgcmVzdWx0cyB5b3UndmUgc2hvd24gcHV0IHRoZSBwYXRjaCBpbiBhIHZlcnkgbmVnYXRpdmUg bGlnaHQgLS0gYXQNCmxlYXN0IGlmIHRha2VuIGF0IGZhY2UgdmFsdWUuIFRoZXJlIGFyZSBhIGZl dyBzbWFsbCBzaW5nbGUgZGlnaXQNCnBlcmNlbnRhZ2UgaW1wcm92ZW1lbnRzLCBidXQgbm8gcG9z aXRpdmUgcmVzdWx0IHRoYXQgaXMNCmRpc3Rpbmd1aXNoYWJsZSBmcm9tIG5vaXNlLiBUaGVyZSBh cmUgc2V2ZXJhbCBxdWVyaWVzIHRoYXQgYXJlIG1vcmUNCnRoYW4gMnggc2xvd2VyLg0KDQpJdCdz IHZlcnkgaGFyZCB0byBiZWxpZXZlIHRoYXQgd2hhdCB5b3UndmUgc2hvd24gY291bGQgYmUgaW4g YW55IHdheQ0KcmVwcmVzZW50YXRpdmUgb2YgdGhlIHBhdGNoIC0tIGl0J3MgY29tcGxldGVseSBh dCBvZGRzIHdpdGggbXkNCmV4cGVyaWVuY2UgdGVzdGluZyB0aGUgcGF0Y2guIEkndmUgc3BlbnQg d2Vla3MgYW5kIHdlZWtzIGxvb2tpbmcgZm9yDQpyZWdyZXNzaW9ucyBpbiB0aGUgcGF0Y2gsIG9m dGVuIHVzaW5nIGFkdmVyc2FyaWFsLCByYW5kb21pemVkIHF1ZXJ5DQpnZW5lcmF0aW9uLiBCdXQg SSBoYXZlbid0IHNlZW4gYW55dGhpbmcgbmVhciBhIDJ4IHNsb3dkb3duLCBmb3IgYW55DQpxdWVy eSwgd2l0aCBhbnkgcG9zc2libGUgY29uZmlnLg0KDQpUaGVyZSdzIG5vIHBvaW50IGluIHNwZWN1 bGF0aW5nIHdoYXQgbWlnaHQgaGF2ZSBoYXBwZW5lZCBoZXJlIHVudGlsIEkNCmNhbiByZXByb2R1 Y2UgeW91ciByZXN1bHRzLCBzbyBJJ2xsIHJlZnJhaW4gZnJvbSB0aGF0Lg0KDQotLQ0KUGV0ZXIg R2VvZ2hlZ2FuDQo=