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 1vx8Gf-00H020-0T for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Mar 2026 18:45:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx8Gc-002TND-2a for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Mar 2026 18:45:19 +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 1vx8Gc-002TN4-1i for pgsql-hackers@lists.postgresql.org; Mon, 02 Mar 2026 18:45:19 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vx8Gb-000000003hn-14dq for pgsql-hackers@lists.postgresql.org; Mon, 02 Mar 2026 18:45:18 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-b8f97c626aaso839193866b.2 for ; Mon, 02 Mar 2026 10:45:17 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772477116; cv=none; d=google.com; s=arc-20240605; b=hNYyYoy4GE9/cnOb5x+VAIDpCcoTtholEFQ3qktVgrJnMJCZE+VaNrj8AuiODkyBMg GVBcU8h83GWnmlO0mrgV0UDYwa6NUlgNQW5vZKNIKxxL1BUS6TS7czykwVADO564l4JG Gci9BCOW2oBTAUmx3lps4nleniJWuaUpsmktfpgixYbglOcLqXw/Y3jadA9MrnmXyPvp vY9eeKtr3XxBwKJgMF6+MwUJe9vtKEY0O/yjsCRcPPOPVyqB1x7BPTUkD7idHmeyLmzl Tia0RajYHeVt5CMwQzO5G9VlW61GOJdeLjrBLVkeQ+u+NNGHtI4Ic8aiFYzYER8KBlVq 4MEg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=m/WqDKKlo/T+54aSblSLjp+n3xGKhB1E1QUDY8g8fwU=; fh=xy+s3P/xHSXhDdUYLwMczpzXszwMDdUzqc1e4m8zXno=; b=BQ3LbUdZo71qLCFPGoLPIUoZPDgG7FGl4XBwwk7TiJvXZvMGgKX963oA1X7x3Riomf ZxMV4i+8l6vm8SP9XCie+SwJ+X2e22Gb7fIZy39LiTcTR34vZhefzIdvZRi3Dpp5QTY4 i79HGLrXF4ShBZVBtV5kVLAXHU6O8mUARY0E7loiEoYVWqqaNHg8LrnxJV3v6jHbF6tQ 6XzOk+5HFGvz9ZfWWUNfoyD0szlES/hg+jNpior2QD8QCCek+l68h/TVdzU9HoCqUgY+ oWFuxfLKP+ujEpcYtdmXHbBToR9LeG82PcA6sH50VpBXiK2C30phNIRbor71VXVYeXDo FZig==; 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=gmail.com; s=20230601; t=1772477116; x=1773081916; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=m/WqDKKlo/T+54aSblSLjp+n3xGKhB1E1QUDY8g8fwU=; b=Ci+ThqEbiI48s1KSlTmsQ/vzCycDYeKcgeQbLBBSbq09bwHjI4MQIEqftEPXdhoxfb FWDJricP/EVQUW7yhJVLv3D/qsIEiyx88C+EGEStV0+qhXhsIPhDOe4sZCyaSQs8pGDO lYYxeaVKfs/SwcatX+PNlZnRkI9ca/3Cy3lYBFDMEpJADTqD2Fx9jVh4QTf3VP9m800K fXbHUlLU0eyEQa5Pn6snfmAPHhy5yI0yQrRRH+LBaLvKt7fOqwEuOY7kNB3Rs24aXh+Z 5xUGaXqf0Gbi/Q7k2Mw7YOVNQDlzNEj/IXSGNk206Tks13Cz6mPOMaZuutRbgHvZUUNj llzQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772477116; x=1773081916; h=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=m/WqDKKlo/T+54aSblSLjp+n3xGKhB1E1QUDY8g8fwU=; b=mpAYT8ps1FxsZEwqKnWEaFUym4fPmd2KycKVzr1hxKlzOJp4VBMbiXVsN6dswViBpt ZZrlix3YtEv2W56q1syIqsenkNf8kYNg/GmaHolLZdiYimi6QM0x7720wTLt6jbhxEIb 17qFcB2KVMoQ6otz0Phth/E3ppnDxaHRUn9Pp4vvcvMoiyxv4UrVQxVzd6nC67KKWpMu MGY8bANpr04sblrz5FcViorJI70jjDty5pcKSYA9xg2+gKhNb70XQWXn3jJEdrrQmCIT o5pvKPM99ZTNgUTm3paJ1hZEW9vIbgVZMrzjCaqn+cyZJMTKiKmeS0DHI0ATvaD4eB1m MqwQ== X-Forwarded-Encrypted: i=1; AJvYcCWlVnPILD4whZyDw1L1+cIPN9+t44eBoPhmHUXtSfPofBVHBlh3YtgHTRRtzAiYlh0orrMuijoqrwsxCKmw@lists.postgresql.org X-Gm-Message-State: AOJu0YxrdDYW77WDmkjSFNBMf2nrmB21K6+6IhZOhXCYGka88Tn8klu1 0nBzVsnZzAwotftFEo+xc9ANAWDS52kOyN3gIdTuer4yJsDQx9vPTOPd5q5ZTChzrx4tyfiuGQY j1hcFonam584F1OjBaILSGqASHC6dZkQ= X-Gm-Gg: ATEYQzyQYJJZmTqs1+sdx/XZ2iy8s42aaO8ywdA9mizJV/nAb4utAIKxPzsC3W0Mzz9 8S8aUjDRFFZ28fPy858XjX3iNg1hRFkvexyJnNE49MzRpt/Wo9vKPSLIoZkA0sXfjjoNPs+mE+D Vy6Al+nj6YfFb2OrJoxG+PHDfEFMpKQJwqA9Cip5y13+yokzzoDANNjBWcKcDhF/1BtBuEnRH6x 2uqcXtOv+uysF9PyrXMXGYUMPXUApU8aWO21TRNQ4lu9NUHhGtJMqUieAg86TN2PDCUdsf3/0lM In7SrjVqQBPQFAtNJB5N540D4LpKmxa6lv9PF99yOw1QtcfnCw== X-Received: by 2002:a17:907:d25:b0:b8f:aa38:70bc with SMTP id a640c23a62f3a-b93764ecb42mr825929766b.38.1772477114804; Mon, 02 Mar 2026 10:45:14 -0800 (PST) MIME-Version: 1.0 References: <64mfcfv7iihc4pmqlxarii4esnmqry52ckz5m7lmwylnfnuxuz@oxh4ioxkjtep> <7e707787-272a-4c52-b5f1-5ac990514ecc@vondra.me> <3cbwjhwkomjv7jifau4yhb357gfnckut3sdrlbmhwzesd3kngj@affs2mpxg4gh> In-Reply-To: <3cbwjhwkomjv7jifau4yhb357gfnckut3sdrlbmhwzesd3kngj@affs2mpxg4gh> From: Alexandre Felipe Date: Mon, 2 Mar 2026 18:45:03 +0000 X-Gm-Features: AaiRm50GgDHyrRoiG0A-uHYvKQ1PYbKu2ONt7RnjLbNQliwrTPbmS7cYrvso--o Message-ID: Subject: Re: index prefetching To: Andres Freund Cc: Tomas Vondra , Peter Geoghegan , Thomas Munro , Nazir Bilal Yavuz , Robert Haas , Melanie Plageman , PostgreSQL Hackers , Georgios , Konstantin Knizhnik , Dilip Kumar Content-Type: multipart/alternative; boundary="000000000000cd0568064c0efccd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cd0568064c0efccd Content-Type: text/plain; charset="UTF-8" Andres, > Unfortunately that has too big a performance penalty for fully cached > workloads :(. Doing buffer mapping lookups ahead of the current point is not > free. Could you elaborate? --000000000000cd0568064c0efccd Content-Type: text/html; charset="UTF-8"
Andres,

> Unfortunately that has too big a performance penalty for fully cached
> workloads :(. Doing buffer mapping lookups ahead of the current point is not
> free.

Could you elaborate?
--000000000000cd0568064c0efccd--