On 7/23/25 02:59, Andres Freund wrote: > 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. >
With direct I/O, I guess? I'll take a look tomorrow. regard -- Tomas Vondra
