public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andres Freund <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: Alexandre Felipe <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Nazir Bilal Yavuz <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Georgios <[email protected]>
Cc: Konstantin Knizhnik <[email protected]>
Cc: Dilip Kumar <[email protected]>
Subject: Re: index prefetching
Date: Mon, 6 Apr 2026 09:09:01 -0400
Message-ID: <jncvx6hst4tpczvvh7ts2lpzr7scbm25vcrp546lhxanvmj4c2@md7nswr4ghys> (raw)
In-Reply-To: <CAH2-Wzn=vwK+9mv5HuNfuaPkhT+0Ou-E1_Y8miGNJZm-WxHORg@mail.gmail.com>
References: <CAH2-Wz=kMg3PNay96cHMT0LFwtxP-cQSRZTZzh1Cixxf8G=zrw@mail.gmail.com>
	<CAH2-WzkFRoTjD9T8ykYDzOMxzGiWFqcAkbK8B=HjfpoMdM4E8A@mail.gmail.com>
	<chsvntdxvsiyigxq4nng36gne4natvxwvsqnkvbjlpaw6bu7co@a6togdo4wbrj>
	<CAH2-Wz=nz-zr=gaXL1od_F7dcr=7d+3jEEveqY-bgcAKF6wZJQ@mail.gmail.com>
	<CAH2-Wz=t3G53xKGYEWqm_QV35ExRgT2k=qhw_VHe5oGjdFRwtA@mail.gmail.com>
	<CAH2-WzkiCK=wELiXPgriN4r7cJzGb3Xg48E9YHrFEyEPTkynOw@mail.gmail.com>
	<s25f6opuqwmz7oad467twvgxc36zmgzguhph43z4sbfkflsjnq@r6cuj7cl36lg>
	<CAH2-Wzm9r6sCDVkXHXLobQFE3WcEPf-pm=g6S93u4W9JLK2VDA@mail.gmail.com>
	<6sphk3ycctmbihlrykts7uj6mjakop6wrq2dhe3vnlmrnldz2f@uuwmkd6jjrxa>
	<CAH2-Wzn=vwK+9mv5HuNfuaPkhT+0Ou-E1_Y8miGNJZm-WxHORg@mail.gmail.com>

Hi,

Peter and I just chatted a bit about the state of the patchset.  Unfortunately
we both think it needs more polish than is doable in the remaining time.


Quite a few people have tried very hard over the last months to get this, and
its dependencies, into a committable shape. The patchset is much better than
it was. The performance is better. Regressions are drastically reduced. The
performance gains are often unbelievably large.

I'd be happy to merge the patchset from the performance POV. I'd be happy to
merge it from a high-level architectural perspective. It's just the pesky
details that need more buffing out than our tired arms can do in the remaining
time.  I think Peter feels similar.


I was kind of wondering if it could make sense to try to push
    "Add slot-based table AM index scan interface."

given just how much better it architecturally is than what we do today. But
that would probably end up with non-trivial tableam changes in consecutive
releases, which doesn't quite seem worth it.


Oh well, PG 20 will be awesome.


Thanks to everyone helping!

Andres

view thread (367+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: index prefetching
  In-Reply-To: <jncvx6hst4tpczvvh7ts2lpzr7scbm25vcrp546lhxanvmj4c2@md7nswr4ghys>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox