PostgreSQL in Depth interview questions
PostgreSQL in Depth interview questions in 12 module banks: what each bank covers, how many questions it holds and the levels they are asked at.
-
Module 1
How PostgreSQL works and how to run it
12 questions: 4 warm-ups and 8 with model answers · Levels: Fresher to senior
-
Module 2
PostgreSQL data types, chosen well
15 questions: 5 warm-ups and 10 with model answers · Levels: Fresher to staff
-
Module 3
Query plans and indexes
15 questions: 5 warm-ups and 10 with model answers · Levels: Fresher to staff
-
Module 4
The planner in depth
14 questions: 3 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 5
MVCC, VACUUM and freezing
14 questions: 3 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 6
Concurrency, locks and safe migrations
15 questions: 3 warm-ups and 12 with model answers · Levels: Fresher to staff
-
Module 7
Partitioning large tables
9 questions: 2 warm-ups and 7 with model answers · Levels: Fresher to staff
-
Module 8
Server-side code and extensions
12 questions: 4 warm-ups and 8 with model answers · Levels: Fresher to staff
-
Module 9
Search, vectors and maps
12 questions: 4 warm-ups and 8 with model answers · Levels: Fresher to staff
-
Module 10
WAL, replication and high availability
14 questions: 3 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 13
Monitoring, tuning and connection pooling
14 questions: 3 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 14
Applications, scaling and what comes next
7 questions: 2 warm-ups and 5 with model answers · Levels: Fresher to staff