Re: index prefetching

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Tomas Vondra <tomas(at)vondra(dot)me>
Cc: 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-08-19 20:00:56
Message-ID: CAH2-WzntXpRR7bxOU4FVZEYzTVP1FLNsJjaJRVg0_U6URnB2mw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 11, 2026 at 11:21 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v32, another revision intended only to fix bit rot.

Attached is v33, another revision intended only to fix bit rot.

--
Peter Geoghegan

Attachment Content-Type Size
v33-0011-aio-Fix-pgaio_io_wait-for-staged-IOs-B.patch application/octet-stream 6.3 KB
v33-0010-Allow-read_stream_reset-to-not-wait-for-IO-compl.patch application/octet-stream 20.7 KB
v33-0012-WIP-aio-bufmgr-Fix-race-condition-leading-to-dea.patch application/octet-stream 3.1 KB
v33-0001-Add-slot-based-table-AM-index-scan-interface.patch application/octet-stream 119.3 KB
v33-0009-Add-EXPLAIN-IO-support-for-plain-index-scans.patch application/octet-stream 13.9 KB
v33-0008-heapam-Add-index-scan-I-O-prefetching.patch application/octet-stream 55.0 KB
v33-0007-heapam-Optimize-pin-transfers-during-index-scans.patch application/octet-stream 6.1 KB
v33-0005-WIP-Adopt-amgetbatch-interface-in-GiST-index-AM.patch application/octet-stream 113.5 KB
v33-0006-WIP-Adopt-amgetbatch-interface-in-SP-GiST-index-.patch application/octet-stream 70.4 KB
v33-0004-Adopt-amgetbatch-interface-in-hash-index-AM.patch application/octet-stream 48.1 KB
v33-0003-Add-amgetbatch-interface-and-adopt-it-in-nbtree.patch application/octet-stream 271.4 KB
v33-0002-Limit-get_actual_variable_range-leaf-page-reads.patch application/octet-stream 7.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Alexander Lakhin 2026-08-19 20:00:01 Test tidscan,sql is not immune to autovacuum in v14