Re: index prefetching

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Rui Zhao <zhaorui126(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, Andres Freund <andres(at)anarazel(dot)de>, 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-11-19 23:01:53
Message-ID: CAH2-WzkvD-JZxAH-J3_Mxz9oxX-nzy=PhhsktTyqpwbGZuAb+w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Oct 18, 2026 at 8:51 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v38.

Attached is v39. Again, this is mostly just to keep the patch series
applying cleanly.

--
Peter Geoghegan

Attachment Content-Type Size
v39-0012-WIP-aio-bufmgr-Fix-race-condition-leading-to-dea.patch application/octet-stream 3.1 KB
v39-0010-WIP-Add-read-stream-request-deduplication.patch application/octet-stream 26.2 KB
v39-0001-Add-amgetbatch-interface-and-adopt-it-in-nbtree.patch application/octet-stream 282.3 KB
v39-0009-Allow-read_stream_reset-to-not-wait-for-IO-compl.patch application/octet-stream 20.6 KB
v39-0011-aio-Fix-pgaio_io_wait-for-staged-IOs-B.patch application/octet-stream 6.3 KB
v39-0008-Add-EXPLAIN-IO-support-for-plain-index-scans.patch application/octet-stream 13.8 KB
v39-0005-WIP-Adopt-amgetbatch-interface-in-SP-GiST-index-.patch application/octet-stream 72.2 KB
v39-0006-Rename-READ_STREAM_SEQUENTIAL-to-READ_STREAM_NO_.patch application/octet-stream 4.6 KB
v39-0003-Adopt-amgetbatch-interface-in-hash-index-AM.patch application/octet-stream 80.1 KB
v39-0007-heapam-Add-index-scan-I-O-prefetching.patch application/octet-stream 56.2 KB
v39-0002-heapam-Optimize-pin-transfers-during-index-scans.patch application/octet-stream 6.2 KB
v39-0004-WIP-Adopt-amgetbatch-interface-in-GiST-index-AM.patch application/octet-stream 114.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2026-11-19 23:07:55 Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed
Previous Message Peter Geoghegan 2026-11-19 22:54:10 Re: auto_explain crashes on EXPLAIN (BUFFERS) of an index scan (19, master)