PostgreSQL Quiz
PostgreSQL 18 asynchronous I/O and PostgreSQL 19 changes, MVCC + xmin/xmax, btree/GIN/GiST/BRIN, JSONB jsonb_path_ops, partial/functional indexes, EF Core + Npgsql, EXPLAIN (ANALYZE, BUFFERS), VACUUM and PgBouncer pitfalls.
Test: PostgreSQL Quiz
Scenario questions with explanations that show exactly where your model of it breaks.
Reading PostgreSQL is free. Pro unlocks the other four modes on all Databases topics, so you can go from understanding it to building it.
Helps to know first
- SeeThe architecture as diagrams, so you can hold the whole system in your head.
- AnimateStep through the flow one stage at a time and watch the data move.
- TestScenario questions with explanations that show exactly where your model of it breaks.
- BuildA guided implementation with code you can run and adapt for production.
Continue reading
All Databases articles →Vector Database Selection for Production RAG
Cosmos DB, AI Search, Qdrant, Pinecone — benchmarks, cost, and operational complexity for production vector search.
Partitioning and Sharding: Range, Hash, List, and Hot Partitions
Vertical vs horizontal vs sharding, range/hash/list strategies, Postgres declarative partitioning + pg_partman, drop-old-partitions instead of DELETE, Cosmos hierarchical partition keys, verifying pruning with EXPLAIN.
Normalization: 1NF to 3NF, Denormalize Reads, Snapshot Truths
1NF/2NF/3NF/BCNF in plain English, when to denormalize via materialized views or CQRS read models, snapshots vs duplication, REFRESH MATERIALIZED VIEW CONCURRENTLY, propagating changes via CDC.
Discussion
Sign in to share your feedback and join the discussion.