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 1vvpSt-004lbH-2K for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Feb 2026 04:28:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvpSs-000Qt4-1I for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Feb 2026 04:28:34 +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 1vvpSr-000Qsq-33 for pgsql-hackers@lists.postgresql.org; Fri, 27 Feb 2026 04:28:34 +0000 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvpSo-00000001QE0-08U7 for pgsql-hackers@lists.postgresql.org; Fri, 27 Feb 2026 04:28:33 +0000 Received: by mail-wm1-x32e.google.com with SMTP id 5b1f17b1804b1-48372efa020so12648935e9.2 for ; Thu, 26 Feb 2026 20:28:30 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772166509; cv=none; d=google.com; s=arc-20240605; b=SP4CMJeLusu+yi/ApLCaRQ4/zrP1qEapZBcxQZJWO6IrGNN1QkxbFGuIPBvBhod/dy lTYo50SZGl0m+n33hZ7vFlinLPb2mhkcyzWJs7J2KCs1x2/E0mqtPLjT0RB0Bz/QNBGa PbRNL9m5cokxH61144xhF8T0SXSTQI8C2SmLNayUaZeu2BatFwPDJJi43K43LeNttIe0 vzPtKV9H8BmulMWVnXNvmxPn5/svhrabOMsH8zGI41rex3Jyjygc/gU3362fmA29GwCg l1oQUI+5sVrxmRwNQe2k2DB6J8BjowBXM1QLepP6RtOUOc+VSiVRUmJ48pZWCdCQ3ea2 bsHw== 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=pffVDOLkCOl9x0hEeXlIBmjTSz9SrweosGK5/O+YEDo=; fh=SMLkrX5jKHijBbIeByaVewv4f2YEUPSQKgOp9GDHy40=; b=jAMiv5zhlgHdyS+ThqFt6H+yvaRFaCX0Yux+PuM4hCcylC6M8w5aFZCs4GbaxXpruo 1BznrzdvrRKGdcXh8/gExxRMDe5RWSzhRdPJpWN8a9NzhsxkEcG1foJSzSGJn+clXyuL snQIw10Y7u0FJU0Z596j3z5PSp/wyf4meeqz6nkXbyy/UxnZJwV2iD4F2wGnX1UAzy4D zPc7lI/S4qivCF5iNjA/M1sgQe7WSCU0zcL96TRgE4P2aOnvSG4tRWIeEf2hxhBXJikQ r8Cmb2mCXRKgFjx4OCE4GVGT24Ig5aqqLnIXtMXFEfsTEGkmjLg8qZxa2Vnzr7FzPUL5 hKBA==; 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=1772166509; x=1772771309; 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=pffVDOLkCOl9x0hEeXlIBmjTSz9SrweosGK5/O+YEDo=; b=CNgZwLoWTj+FljWMrISvDoVslRGMzCrlpPgfuja26tgfbBTKFwHiW0OkOkb8f5kwtg mxtTgyudr5Qef9EA9smqT/42qV9oN3LF3Auezc1EzjpU9PN7h3pz7vcmevXEQy0gjk/5 v9qmxtb1r8w3paAXJMALWcp96VQo1UMj3NOKR2JXilxSoir5AFHKe6ttsA9P04fSqU07 +lmJq5tFxUpOgmMDbZVpnbRcmVOTF5CdvVmelpfXZpHKw4DbJ+/LjtcAzrQOOEXhVzsa +oJpqiTBt0wOfAsTtx1kJsgGeMEPbcBAtjCKlpZ8xobPROjlCXhGPGlWB7Wk6DvYU4Vg ttMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772166509; x=1772771309; 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=pffVDOLkCOl9x0hEeXlIBmjTSz9SrweosGK5/O+YEDo=; b=xAf4dxJmSTarSQloNysEnqk7P7Zm4fxjHyFwOYOk8ydeLHTGiInJ6uAtFeY/J7DU4l xfPTIoYZepLg40X8H2soGIL2hrJABQNhpLXIiQEZm6JqhIC4OUIp3Z4pdsO6Yqn9UdUq Oc1pxt2VJsFJydhCEL9i2c1iojCiOF99WNQEILniwQ8Rc2iHuwdOleEZjy0hiKIm08KS 1LBgmB5DufLNVSWVxkFihP8U1SHrHk9npxsSmiUqjPI3aWkb6lPIfaojGcFx/aIcrtO/ VIMCVR4xgR7+UrKdMlHQYcV90MqVss5doR2UiSdeNzZQ5fcYIMmDd6gmGZV+C6bAKCCU +27w== X-Forwarded-Encrypted: i=1; AJvYcCXIluc0eNyGmB2zdu6zerUE2JB3ewcRN2Zb6PsbsRlJh2TxmnK/lqgEf7kMNITYb++a1b8sNKYngJ1D1Vrr@lists.postgresql.org X-Gm-Message-State: AOJu0YxfKCRUBRmHcHXSMz0uVsaRxdJjC1BdjnhKWWRT4NcBqHRwpGPT YX6Y0rSh21gEXkwWsVtVbwpWPzKJF6u1asQ1+A0dw7o5JqPi+tFN0ipH5Y5o9xIYwlCCTuzJRiu 4t2F3qblIe9YRMSzJiFeNJ972nmVjbS5W1OKzDp7xZA== X-Gm-Gg: ATEYQzxQSmV5W5bBWP3gSI29FDCui0eXuk34I6giMU62zaBs1LJE64ULwlLHybKbjwR mmP5cRjqSaqZjC58xX5VkPWM8tuPaOep+Hq3oTgOfDW0Tk+2Hq9/T4EW/LxiqLhf/KaS6TLr2/b jlP03zmHTXaXE1uqvZ2RwHVco9oGyTfltW57xLeg7Fv/jcre013359rtQzhjk1+monmQz2lpBIq XAYPTiV0Gn3oxDn0XQ2QjVKg7FiDH/100GPDR1ZrxQsOHlH7uozgo3qJWemxRHvOS2ZYh9TmRbq YcU9rVA= X-Received: by 2002:a05:600c:1548:b0:480:1c10:5633 with SMTP id 5b1f17b1804b1-483c9c1045cmr16399375e9.26.1772166508883; Thu, 26 Feb 2026 20:28:28 -0800 (PST) MIME-Version: 1.0 References: <64a2re223ajj4popowsyu4xekbuvvyfwkrihn5yzyrkwsmsuvp@2lls3tpww5dl> <52512325-b1f2-4fff-819e-f68122b2e427@vondra.me> <64mfcfv7iihc4pmqlxarii4esnmqry52ckz5m7lmwylnfnuxuz@oxh4ioxkjtep> In-Reply-To: From: Peter Geoghegan Date: Thu, 26 Feb 2026 23:28:02 -0500 X-Gm-Features: AaiRm51Kz92uXjqmHcCaXKQABHxLBSDCHb92j2H4rSPC7TcIK7loQL84GeIQPqY Message-ID: Subject: Re: index prefetching To: Andres Freund Cc: Tomas Vondra , Alexandre Felipe , 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: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Feb 26, 2026 at 11:18=E2=80=AFPM Andres Freund = wrote: > Of course this is a silly query, but you'd also see that with a mergejoin= or > such. Can you post the query? -- Peter Geoghegan