Mastodawn

Ich habe gerade eine Woche damit verbracht, einen Bug in meinem Kernel zu jagen, nur um festzustellen, dass es ein Fehler in QEMU TCG ist, der dafür sorgt, dass manche CPUs keine Timer-Interrupts mehr bekommen.
(I just spent a week hunting down a bug in my kernel, only to discover that it's a flaw in QEMU TCG that causes some CPUs to stop receiving timer interrupts.)
#telix #qemu #tickless #FullPreemption #GangScheduling #AsynchronousIO #MessagePassingVFS #SchedulerActivations

Vielleicht sollte ich meinen Page-Clustering-Branch auf Linux 7.0 aktualisieren, aber ich bin unsicher, ob ich dafür ein eigenes Tag setzen soll oder was ich da am besten mache.
(Perhaps I should update my page clustering branch to Linux 7.0, but I'm unsure whether I should set a separate tag for it or what the best course of action is.)
#linux #pgcl

N-gated Hacker News Sep 29, 2025

🎉🎩 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 News May 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 News May 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

DasMammut Feb 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 ?!? 😩