| 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-05-27 19:11:52 |
| Message-ID: | CAH2-Wz=V0V5WGuo85D-OF+TM_CxU3q=MMkY-ebY0K8xc-9Xykw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Apr 6, 2026 at 11:39 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v24 -- one last revision ahead of feature freeze, just to
> post what I have, before taking some time away from this.
I'm resuming work on this project, now targeting Postgres 20.
Attached is v25, which I'm posting now to keep CFTested happy and to
ensure the patch set applies cleanly against the master branch. There
are no substantive changes here compared to v24.
I would like to get the first patch committed soon-ish (the one that
revises the table AM by making index scans use a higher-level,
slot-based interface). Maybe in the next 4-8 weeks. That piece is much
simpler than the later ones.
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| v25-0001-Add-slot-based-table-AM-index-scan-interface.patch | application/octet-stream | 84.8 KB |
| v25-0007-aio-Fix-pgaio_io_wait-for-staged-IOs-B.patch | application/octet-stream | 6.3 KB |
| v25-0008-WIP-aio-bufmgr-Fix-race-condition-leading-to-dea.patch | application/octet-stream | 3.1 KB |
| v25-0005-heapam-Add-index-scan-I-O-prefetching.patch | application/octet-stream | 48.3 KB |
| v25-0006-Allow-read_stream_reset-to-not-wait-for-IO-compl.patch | application/octet-stream | 20.5 KB |
| v25-0003-Adopt-amgetbatch-interface-in-hash-index-AM.patch | application/octet-stream | 48.0 KB |
| v25-0004-heapam-Optimize-pin-transfers-during-index-scans.patch | application/octet-stream | 6.8 KB |
| v25-0002-Add-amgetbatch-interface-and-adopt-it-in-nbtree.patch | application/octet-stream | 247.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2026-05-27 19:21:18 | Re: effective_wal_level is not decreasing after using REPACK (CONCURRENTLY) |
| Previous Message | Tomas Vondra | 2026-05-27 19:08:34 | Re: Is there value in having optimizer stats for joins/foreignkeys? |