On Wed, 8 Oct 2025 at 08:15, Greg Sabino Mullane <[email protected]> wrote: > I've been doing this sort of thing for clients a long time, and I always test > both directions when I come across a query that should be faster. For > real-world queries, 99% of them have no change or improve with a lowered rpc, > and 99% get worse via a raised rpc. So color me unconvinced.
I wonder how much past experience for this on versions before v18 count in now that we have AIO. The bar should have moved quite significantly with v18 in terms of how often Seq Scans spend waiting for IO vs Index Scans. So maybe Tomas's results shouldn't be too surprising. Maybe the graph would look quite different with io_method = 'sync'.. ? David
