Hi,
On 2026-02-26 23:28:02 -0500, Peter Geoghegan wrote:
> On Thu, Feb 26, 2026 at 11:18 PM Andres Freund <[email protected]> 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
