Checkout the slides

PostgreSQL I/O Patterns

In this talk, we would like to talk about PostgreSQL database systems I/O patterns. In PostgreSQL, we do have I/O patterns like

• Checkpoint
• Background Writer
• Vacuum/Autovacuum
• Client Backend
• Bulk Read/Writes
• WAL I/O
• Query I/O
• Query Parallel Reads
• Index I/O

Also, dive deep into PostgreSQL catalog tables, which actually talks about I/O, and helps to tune and do the right sizing of the instance.