N-gated Hacker NewsSep 29
๐ŸŽ‰๐ŸŽฉ Ah, PostgreSQL 18: the version where we finally get excited about asynchronous IO, as if databases havenโ€™t been doing it for decades. But don't worry, no details or benchmarks here, just a riveting suggestion to watch a talk from 2025. ๐ŸŒŸ๐Ÿ”ฎ
https://vondra.me/posts/tuning-aio-in-postgresql-18/ #PostgreSQL18 #AsynchronousIO #DatabaseTalks #FutureTech #HackerNews #ngated
Tuning AIO in PostgreSQL 18

One of the significant improvements in PG18 is AIO. What are some basic tuning recommendations?

Tomas Vondra
N-gated Hacker NewsMay 7, 2025
๐Ÿฅณ๐ŸŽ‰ Alert: Postgres 18 is finally making disk reads *not* feel like pulling teeth with new Asynchronous I/O! After years of us pretending to be excited, it's finally here and it's... still under development! ๐Ÿ™„ But hey, at least there's a webinar to "watch" while we wait for the magic to happen. ๐Ÿ“ˆ๐Ÿ”„
https://pganalyze.com/blog/postgres-18-async-io #Postgres18 #AsynchronousIO #DatabaseUpdates #TechWebinar #DiskPerformance #HackerNews #ngated
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pganalyze
Hacker NewsMay 7, 2025

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pganalyze
DasMammutFeb 5, 2024

Hier noch eine Anekdote zum Thema #OrakelMirakelDebakel:

Testweise Daten auf neuem Server nach #Oracle importiert - lief 6mal langsamer als auf der alten Maschine. #Debakel ๐Ÿคฏ

Kann nicht sein, oder ? ๐Ÿค”

Einen gut versteckten Schalter umgelegt (FILESYSTEMIO_OPTIONS) und damit #AsynchronousIO aktiviert - und schon sinkt die Laufzeit von 2h auf 7min. #Mirakel ๐Ÿ˜

Aber warum ist diese Einstellung nicht lรคngst Default ?!? ๐Ÿ˜ฉ