Schedule - PGConf.EU 2023
Getting the most out of pg_stat_io
Starting with PostgreSQL 16 there is a new catalog view called "pg_stat_io". Traditionally PostgreSQL did not provide much details when it comes to I/O statistics and this will change from version 16 on. This is all about extends, reads and writes, and statistics related to the buffer cache. By attending this talk you'll get a better understanding what PostgreSQL is doing I/O wise and we'll also cover direct I/O, which currently is a developer feature which is supposed to evolve over the next releases.