In this talk I will: 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh introduce the unusual I/O needs of databases and PostgreSQL's new I/O architecture and direction 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh show how PostgreSQL works on FreeBSD, NetBSD, OpenBSD and illumos today 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh compare those systems' available support for native asynchronous I/O with Windows and Linux 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh speculate on the pathways that need to be drilled through their kernels to achieve the state of the art 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh speculate on the API design constraints and options I see 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh discuss OpenZFS's exciting new direct I/O and block cloning features and their relevance to PostgreSQL 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh show-and-tell some experimental patches for full-featured direct I/O on FreeBSD's UFS 2025 2026 generate_markdown.sh iife.js notes peertube_upload.sh quikdown_bd.esm.min.js quikdown.esm.min.js quikdown.esm.min.js.1 quikdown.umd.min.js quikdown.umd.min.js.1 scheduel.xml schedule.xml showdown.js showdown.js.1 showdown.min.js turndown.browser.es.js upload.js upload_peertube.sh show-and-tell some experimental patches for PostgreSQL with FreeBSD's native AIO and kqueue

My goal is to provide a database hacker's take on the I/O concerns that "go together" and explain how and why they are linked. It is written for a cross-project kernel and file system hacker audience, a rare opportunity provided by this FOSDEM devroom. The presentation begins with a high-level problem space overview, before diving down to user space, VFS and device levels to discuss the options as I see them. It includes some exploratory patches developed over the past few years of working full time on PostgreSQL I/O, porting and testing on ~10 operating systems, and hacking on FreeBSD for fun and education.

It is a 25 minute talk, broken up into 5 subtopics consisting of 5 one-minute slides, and the pace will be fast:

speakers: 'Thomas Munro'

link: 'https://fosdem.org/2026/schedule/event/K9TAKD-optimising-postgresql-on-bsd/'