| 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-09-15 18:47:38 |
| Message-ID: | CAH2-WzmR--gW+FrO5z7Uis6GEN84Bh3z_QVbK+QXKXnCYkz3aw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Sep 14, 2026 at 2:08 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v35, which addresses my outstanding concerns about include
> dependencies. Some changes in v35 are similar to ones you
> independently proposed. Even still, thanks for the review.
>
> I will commit 0001 later this week. That kept getting held up by small
> issues, but I finally think I've fixed all of them.
I finally committed the "Add slot-based table AM index scan interface"
work. I also committed Tomas' fix for the pending_read_nblocks read
stream bug that appeared as part of v35.
Attached is v36, which is just to keep the patch series applying.
This version also lacks the "Add get_actual_variable_range index page
read limit" patch carried by previous versions, which I have not
committed. It no longer makes sense to treat that patch as part of
this project, even though it started out that way. It has independent
goals, and no longer relies on any patch carried in this series. So
there's a separate CF entry/thread for it now [1].
[1] https://commitfest.postgresql.org/patch/7305/
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| v36-0007-Add-EXPLAIN-IO-support-for-plain-index-scans.patch | application/x-patch | 14.0 KB |
| v36-0010-WIP-aio-bufmgr-Fix-race-condition-leading-to-dea.patch | application/x-patch | 3.1 KB |
| v36-0009-aio-Fix-pgaio_io_wait-for-staged-IOs-B.patch | application/x-patch | 6.3 KB |
| v36-0008-Allow-read_stream_reset-to-not-wait-for-IO-compl.patch | application/x-patch | 20.6 KB |
| v36-0001-Add-amgetbatch-interface-and-adopt-it-in-nbtree.patch | application/x-patch | 279.4 KB |
| v36-0006-heapam-Add-index-scan-I-O-prefetching.patch | application/x-patch | 53.6 KB |
| v36-0005-WIP-Adopt-amgetbatch-interface-in-SP-GiST-index-.patch | application/x-patch | 70.5 KB |
| v36-0003-Adopt-amgetbatch-interface-in-hash-index-AM.patch | application/x-patch | 48.6 KB |
| v36-0004-WIP-Adopt-amgetbatch-interface-in-GiST-index-AM.patch | application/x-patch | 112.9 KB |
| v36-0002-heapam-Optimize-pin-transfers-during-index-scans.patch | application/x-patch | 6.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | surya poondla | 2026-09-15 18:48:49 | Re: pg_xmin_horizon: a system view of everything pinning the xmin horizon |
| Previous Message | David Steele | 2026-09-15 18:45:38 | Re: Return pg_control from pg_backup_stop(). |