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>, 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: 2025-11-09 20:13:22
Message-ID: CAH2-Wzn10LK3dg3zhTH2+GkUq6iKH7izaEPZX=uu9Yoe1WYakg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 5, 2025 at 11:55 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Same story again today. The recent "Sort guc_parameters.dat
> alphabetically by name" commit made the patch no longer compile.

Same again. This new revision fixes bitrot caused by Andres' recent
"bufmgr: Allow some buffer state modifications while holding header
lock" commit.

I had to fix some of Andres' code to get this working. I think that I
got this right, but haven't tested those changes very well.

--
Peter Geoghegan

Attachment Content-Type Size
v20251109-0001-bufmgr-aio-Prototype-for-not-waiting-for-a.patch application/octet-stream 6.9 KB
v20251109-0002-Add-amgetbatch-interface-for-index-scan-pr.patch application/octet-stream 161.7 KB
v20251109-0003-Reduce-malloc-free-traffic-by-caching-batc.patch application/octet-stream 11.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2025-11-09 21:30:47 Re: DOCS: What SGML markup to use for user objects like tables, columns, etc?
Previous Message Peter Geoghegan 2025-11-09 19:51:08 Re: Don't synchronously wait for already-in-progress IO in read stream