Postgres 5분 E57: Postgres 16의 새로운 pg_stat_io 뷰와 일반 DBA의 관점

Today, I want to talk about the pg_stat_io view and the everyday DBA perspective on why it matters. We’ll go through tracking activity in Postgres with pg_stat_io and talk about getting insights into extends, evictions, reuses, and more.

*Find the article on our blog here:*

https://pganalyze.com/blog/5mins-postgres-16-pg-stat-io-dba

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*

https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics - by depesz*

https://www.depesz.com/2023/02/27/waiting-for-postgresql-16-add-pg_stat_io-view-providing-more-detailed-io-statistics/

*Add pg_stat_io view, providing more detailed IO statistics - postgres commitdiff*

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a9c70b46dbe152e094f137f7e6ba9cd3a638ee25

*Andres Freund on Twitter*

https://twitter.com/andresfreundtec

*Melanie Plageman on Twitter*

https://twitter.com/melanieplageman

*Track IO times in pg_stat_io*

https://commitfest.postgresql.org/42/4217/

*pgbench*

https://www.postgresql.org/docs/current/pgbench.html

*Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io - by Lukas Fittl*

https://pganalyze.com/blog/pg-stat-io