Re: index prefetching

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, Alexandre Felipe <o(dot)alexandre(dot)felipe(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Georgios <gkokolatos(at)protonmail(dot)com>, Konstantin Knizhnik <knizhnik(at)garret(dot)ru>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Subject: Re: index prefetching
Date: 2026-03-14 00:50:50
Message-ID: CAH2-WzmCH+N2-H2oGSQcbn2fArbk7GXyD6rQN6kn5P=FX9R-_g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 12, 2026 at 3:44 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached v13 does things this way.

Several patches from this patchset have been committed to master. I'm
posting a new version (v14) here to keep the patch applying cleanly.

There are no notable changes to the patches themselves here -- just
some minor cleanup of the docs, and some comments.

--
Peter Geoghegan

Attachment Content-Type Size
v14-0016-Make-hash-index-AM-use-amgetbatch-interface.patch application/octet-stream 42.0 KB
v14-0013-WIP-read_stream-Prevent-distance-from-decaying-t.patch application/octet-stream 2.9 KB
v14-0014-WIP-aio-io_uring-Use-IO-size-not-IO-queue-to-tri.patch application/octet-stream 4.1 KB
v14-0001-Make-IndexScanInstrumentation-a-pointer-in-execu.patch application/octet-stream 9.1 KB
v14-0015-Add-fake-LSN-support-to-hash-index-AM.patch application/octet-stream 14.0 KB
v14-0009-WIP-read_stream-Issue-IO-synchronously-while-in-.patch application/octet-stream 2.0 KB
v14-0011-bufmgr-Return-whether-WaitReadBuffers-needed-to-.patch application/octet-stream 2.8 KB
v14-0010-WIP-aio-io_uring-Allow-IO-methods-to-check-if-IO.patch application/octet-stream 4.6 KB
v14-0012-WIP-read_stream-Only-increase-distance-when-wait.patch application/octet-stream 2.3 KB
v14-0008-Don-t-wait-for-already-in-progress-IO.patch application/octet-stream 20.6 KB
v14-0006-Use-ExecSetTupleBound-hint-during-index-scans.patch application/octet-stream 10.9 KB
v14-0007-Make-buffer-hit-helper.patch application/octet-stream 6.0 KB
v14-0005-Add-heapam-index-scan-I-O-prefetching.patch application/octet-stream 45.5 KB
v14-0003-Add-interfaces-that-enable-index-prefetching.patch application/octet-stream 250.9 KB
v14-0004-Limit-get_actual_variable_range-to-scan-three-in.patch application/octet-stream 10.4 KB
v14-0002-heapam-Track-heap-block-in-IndexFetchHeapData-us.patch application/octet-stream 3.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2026-03-14 03:02:04 Re: [19] CREATE SUBSCRIPTION ... SERVER
Previous Message Zsolt Parragi 2026-03-13 23:20:15 Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input