PostgreSQL Deep Dive

Question

A deep dive on PostgreSQL internals.

What this round covers

• Row-level security and policies
• Indexes (B-tree, GIN), query planning, EXPLAIN
• Triggers, functions, and extensions (pgvector, pg_bouncer)
• MVCC, vacuum, and transaction isolation

Tips

Be ready to model data and reason about the planner and RLS.