Interview Questions

PostgreSQL

20 topics questions ~NaNh to complete
Start prep →

Topics

  1. Backup, PITR, and Disaster Recovery 10 questions
  2. Connection Pooling and PgBouncer 10 questions
  3. Extensions: PostGIS, TimescaleDB, Citus 10 questions
  4. High Availability: Patroni and Stolon 10 questions
  5. Index Types: B-tree, GIN, GiST, BRIN 10 questions
  6. JSONB and Document Storage Patterns 10 questions
  7. Locking, Deadlocks, and Concurrency 10 questions
  8. Logical Replication and CDC Patterns 10 questions
  9. Major Version Upgrade Strategies 10 questions
  10. Memory Configuration and Shared Buffers 10 questions
  11. MVCC and Transaction Isolation Internals 10 questions
  12. Parallel Query Execution 10 questions
  13. Table Partitioning Strategies 10 questions
  14. pg_stat_statements and Performance Monitoring 10 questions
  15. Query Planner, EXPLAIN, and Optimization 10 questions
  16. Row-Level Security and Multi-Tenancy 10 questions
  17. Statistics and Cost Estimation 10 questions
  18. TOAST and Large Object Storage 10 questions
  19. Vacuum, Autovacuum, and Bloat Management 10 questions
  20. WAL, Replication, and Streaming 10 questions