John gives us the basics of i/o in Postgres from how it works, to what parts of the database use IOPS, how to measure it, and what to do to optimize it. John also explains new view for pg_stat_io just released with Postgres 16 and how this can be used for performance analysis.| Crunchy Data
9.26. System Information Functions and Operators # 9.26.1. Session Information Functions 9.26.2. Access Privilege Inquiry Functions 9.26.3. Schema Visibility Inquiry Functions …| PostgreSQL Documentation
26.3. Continuous Archiving and Point-in-Time Recovery (PITR) # 26.3.1. Setting Up WAL Archiving 26.3.2. Making a Base Backup 26.3.3. Making a …| PostgreSQL Documentation
28.2. The Cumulative Statistics System # 28.2.1. Statistics Collection Configuration 28.2.2. Viewing Statistics 28.2.3. pg_stat_activity 28.2.4. pg_stat_replication 28.2.5. pg_stat_replication_slots 28.2.6. pg_stat_wal_receiver …| PostgreSQL Documentation
Feature Matrix | www.postgresql.org
