Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io - 5mins of Postgres E64
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In episode 64 of “5mins of Postgres” we talk about two improvements to the new pg_stat_io view in Postgres 16: tracking shared buffer hits and tracking I/O time. We look at the concept of a 'normal' I/O operation and the addition of the read time and write time columns to pg_stat_io.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ 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:
pg_stat_io on postgresql.org
https://www.postgresql.org/docs/devel...
How Postgres DBAs can use pg_stat_io
https://pganalyze.com/blog/5mins-post...
Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
https://pganalyze.com/blog/pg-stat-io
Track shared buffer hits in pg_stat_io commit
https://git.postgresql.org/gitweb/?p=...
pg_stat_database on postgresql.org
https://www.postgresql.org/docs/curre...
Track IO times in pg_stat_io commit
https://git.postgresql.org/gitweb/?p=...
Melanie Plageman on Twitter
/ melanieplageman
pganalyze Webinar: Optimizing Postgres I/O Performance and Costs
https://pganalyze.com/webinars/optimi...