Postgres 18 is bringing a major performance improvement: async io. This uses the Linux io_uring interface to make table scans, bitmap heap scans, and VACUUM operations leverage async io, greatly speeding up these operations. pganalyse has a great article on this (link below)