Postgres I/O Basics, and how to efficiently pack table pages

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-io-basics

In E85 of “5mins of Postgres” we’ll talk about understanding Postgres IOPS and how Postgres structures its physical table structure.

*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:*

*Understanding Postgres IOPS: Why They Matter Even When Everything Fits in Cache*

https://www.crunchydata.com/blog/understanding-postgres-iops

*John Dalton on Twitter/X*

https://twitter.com/johndalton

*John Dalton on Mastodon*

https://mastodon.cloud/@johndalton

*pg_proctab on GitLab*

https://gitlab.com/pg_proctab/pg_proctab

*Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io*

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

*How Postgres DBAs can use pg_stat_io*

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

*Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io*

https://pganalyze.com/blog/5mins-postgres-16-buffer-cache-hit-ratio-io-times-pg-stat-io

*Understanding how sparsely tuples are stored in a table - by Nikolay Samokhvalov*

https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos/-/blob/main/0004_tuple_sparsenes.md

*Nikolay Samokhvalov on Twitter/X*

https://twitter.com/samokhvalov

*How to debug slow Postgres UPDATEs and bloated tables with auto_explain & page_inspect*

https://pganalyze.com/blog/5mins-postgres-debug-UPDATE-bloated-tables-auto-explain-pageinspect