Personal Favorites

• Generating Fractals with SQL Queries
• The Missing Postgres Scan: The Loose Index Scan
• Postgres MVCC
• Postgres Transactions Aren’t Fully Isolated
• The File Layout of Postgres Tables

---

Query Execution

• Postgres Sequential Scans
• Postgres Index Scans
• Postgres Bitmap Scans
• Postgres Nested Loop Joins
• Postgres Hash Joins
• Postgres Merge Joins

Performance Optimization

• Using Explain in Postgres
• Using Explain Analyze in Postgres
• explain.despez.com
• Speeding up Postgres Index Scans with Index-Only Scans
• Postgres Heap Only Tuples
• The Missing Postgres Scan: The Loose Index Scan

ACID

• Transactions in Postgres
• Postgres MVCC
• The Postgres Commit Log
• Postgres WAL
• The Postgres Vacuum
• Transaction Id Wraparound in Postgres
• Postgres Vacuum Full
• Postgres Transactions Aren’t Fully Isolated
• Postgres Row Level Locks
• Postgres Transaction Isolation Levels

SQL

• Postgres CTEs
• Understanding Postgres Recursive CTEs
• Postgres Lateral Joins
• SELECT DISTINCT ON … ORDER BY
• Postgres Window Functions
• Postgres Upserts
• How to Write a Postgres SQL UDF

Other

• How Postgres Plans Queries
• The File Layout of Postgres Tables
• Generating Fractals with SQL Queries