Hi, On 2025-07-23 02:50:04 +0200, Tomas Vondra wrote: > But I don't see why would this have any effect on the prefetch distance, > queue depth etc. Or why decreasing INDEX_SCAN_MAX_BATCHES should improve > that. I'd have expected exactly the opposite behavior. > > Could be bug, of course. But it'd be helpful to see the dataset/query.
Pgbench scale 500, with the simpler query from my message. Greetings, Andres Freund
