Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Additional IO Observability in Postgres with pg_stat_io | Citus Con 2023

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.5K views 1 year ago #PostgreSQL #Database #CitusCon
Video of a conference talk on pg_stat_io and Postgres observability presented by Melanie Plageman at Citus Con: An Event for Postgres 2023. pg_stat_io is a new cumulative statistics view in Postgres that provides additional visibility into IO activity—split out by backend type, IO context, and IO operation. Previously IO statistics in Postgres, both those built-in and those available through extensions, did not divide IO activity at a sufficient level of granularity to inform tuning decisions. pg_stat_io addresses these gaps. This talk explains the causes of common IO bottlenecks using pared-down walk-throughs of the internal Postgres systems responsible for accessing and persisting your data. Then, through systematic breakdowns of potential symptoms visible in pg_stat_io, it explores the most likely misconfigurations leading to these issues. Melanie Plageman is a Postgres hacker working at Microsoft. She has worked on the Postgres executor, …...more
...more
Additional IO Observability in Postgres with pg_stat_io | Citus Con 2023
43Likes
1,538Views
2023May 8
Video of a conference talk on pg_stat_io and Postgres observability presented by Melanie Plageman at Citus Con: An Event for Postgres 2023. pg_stat_io is a new cumulative statistics view in Postgres that provides additional visibility into IO activity—split out by backend type, IO context, and IO operation. Previously IO statistics in Postgres, both those built-in and those available through extensions, did not divide IO activity at a sufficient level of granularity to inform tuning decisions. pg_stat_io addresses these gaps. This talk explains the causes of common IO bottlenecks using pared-down walk-throughs of the internal Postgres systems responsible for accessing and persisting your data. Then, through systematic breakdowns of potential symptoms visible in pg_stat_io, it explores the most likely misconfigurations leading to these issues. Melanie Plageman is a Postgres hacker working at Microsoft. She has worked on the Postgres executor, planner, storage, and statistics subsystems. Most recently Melanie has been hacking on the proposed asynchronous and direct IO patch set. She is passionate about writing maintainable code and about building developer tools. ► Video bookmarks: ⏩ 00:00 Introducing Melanie ⏩ 01:01 Melanie’s talk begins: Tuning with pg_stat_io ⏩ 01:49 I/O Goals, Tuning, and Statistics ⏩ 06:22 pg_stat_io ⏩ 11:10 Postgres autovacuum workflow ⏩ 16:04 Data-Driven Tuning with pg_stat_io ⏩ 22:28 Q&A ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   More resources: 📣 Slides for this talk: https://speakerdeck.com/melanieplagem... #CitusCon #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

588K subscribers