Hi,
On 2026-02-26 23:28:02 -0500, Peter Geoghegan wrote:
> On Thu, Feb 26, 2026 at 11:18 PM Andres Freund <andres@anarazel.de> wrote:
> > Of course this is a silly query, but you'd also see that with a mergejoin or
> > such.
>
> Can you post the query?
Oops, I had intended to paste it with the first of the explains...
SET enable_indexscan_prefetch = 1; SELECT pg_buffercache_evict_relation('pgbench_accounts'); SELECT
pg_prewarm('pgbench_accounts_pkey');EXPLAIN(ANALYZE) SELECT * FROM pgbench_accounts ORDER BY aid;
Greetings,
Andres Freund
