Learning path
PostgreSQL Interview Prep
The core topics interviewers probe: plans, indexes, transactions, MVCC and locks.
candidates, backend · Intermediate · 4 courses · 4 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course Reading a Query Plan →
- Course B-tree Indexes and Selectivity →
- Course Transactions and Isolation Levels →
- Course MVCC and VACUUM →
- query-performance Missing index on a hot endpoint →
- query-performance Wrong column order in a composite index →
- locks-transactions Deadlock from inconsistent lock ordering →
- vacuum-bloat Table bloat after update churn →