[pgaddict]

I did a lot of tests comparing the io_method choices, and I'm yet to see a realistic query where it makes a significant difference of more than a couple percent (in either direction). I'm sure it's possible to construct such queries, and it's interesting, but for real workloads it's mostly not noticeable.

At least that's how I see it right now, we'll see how that works on a much wider range of hardware and systems. The github repo linked from the pgsql-hackers post has a lot more results, some charts include results for the index prefetching patch - and there it makes more difference in some cases. But the patch is still fairly rough, it could be a bug in it too, and it changed a lot since August.

[bluetech]

Which Linux version did you use for the io_uring tests? Unless I missed it I don't see it mentioned.

[pgaddict]

Debian 12/13, with kernel 6.15.

Sorry, should have mentioned that in the blog post.