Tomas Vondra, a PostgreSQL developer, writes detailed benchmarks and analysis of Postgres performance, I/O, memory tuning, and the Postgres community.
HN links his benchmark posts, such as async IO tuning in Postgres 18 and BOLT optimization, which one commenter says gave gains of up to 40%.
That explains why `sync` and `worker` have so similar results in almost all runs. The benchmarks from Tomas Vondra (https://vondra.me/posts/tuning-aio-in-postgresql-18/) showed some significant differences.
Here is another interesting BOLT article, this one on PostgreSQL optimization:
https://vondra.me/posts/playing-with-bolt-and-postgres/
"results are unexpectedly good, in some cases up to 40%"