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-04-04 04:16:37
Message-ID: CAH2-Wzn0L6z6PO+qM6-66KWr7qJshZF9nWZFEcELORvZ30E4zg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 3, 2026 at 1:17 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v21, which advances things in the direction established in
> v20. It also fixes bitrot -- we no longer carry certain read stream
> related patches from Andres that were committed since I posted v20 a
> couple of days ago.

The patch bitrot again. Attached is v22 to fix that.

Nothing terribly interesting here, compared to v21. I spent quite a
lot of time on the documentation today. This involved general
polishing, some of which focused on making the documentation better
align with the changes from v20 and v21.

--
Peter Geoghegan

Attachment Content-Type Size
v22-0014-aio-Fix-pgaio_io_wait-for-staged-IOs-B.patch application/octet-stream 6.3 KB
v22-0001-Rename-heapam_index_fetch_tuple-argument-for-cla.patch application/octet-stream 2.6 KB
v22-0015-WIP-aio-bufmgr-Fix-race-condition-leading-to-dea.patch application/octet-stream 3.1 KB
v22-0013-WIP-read-stream-Split-decision-about-look-ahead-.patch application/octet-stream 14.8 KB
v22-0012-Hacky-implementation-of-making-read_stream_reset.patch application/octet-stream 5.1 KB
v22-0011-read_stream-Only-increase-distance-when-waiting-.patch application/octet-stream 4.2 KB
v22-0010-aio-io_uring-Trigger-async-processing-for-large-.patch application/octet-stream 7.2 KB
v22-0009-Make-hash-index-AM-use-amgetbatch-interface.patch application/octet-stream 47.8 KB
v22-0008-heapam-Add-index-scan-I-O-prefetching.patch application/octet-stream 47.6 KB
v22-0007-heapam-Optimize-pin-transfers-during-index-scans.patch application/octet-stream 6.7 KB
v22-0004-heapam-Track-heap-block-in-IndexFetchHeapData.patch application/octet-stream 4.7 KB
v22-0005-heapam-Keep-buffer-pins-across-index-rescans.patch application/octet-stream 4.2 KB
v22-0006-Add-interfaces-that-enable-index-prefetching.patch application/octet-stream 241.3 KB
v22-0002-Move-heapam_handler.c-index-scan-code-to-new-fil.patch application/octet-stream 21.3 KB
v22-0003-Add-slot-based-table-AM-index-scan-interface.patch application/octet-stream 79.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2026-04-04 05:21:53 Re: index prefetching
Previous Message David Rowley 2026-04-04 03:30:32 Re: Small and unlikely overflow hazard in bms_next_member()