A Dev Writes
The Vault Courses
The Vault Courses

Course Modules

Advanced PostgreSQL
01 Advanced SQL 6
Advanced SQL & Internals Window Functions Recursive CTEs JSONB Queries Module Review: Advanced SQL
02 Indexing 5
B-Tree vs GIN vs GiST Partial Indexes Covering Indexes Module Review: Indexing Strategies
03 Query Performance 5
Execution Plans Join Algorithms Statistics Collector Review & Cheat Sheet
04 Concurrency 5
MVCC Internals Isolation Levels Explicit Locking Module Review: Concurrency
05 Replication 5
Streaming Replication Logical Replication Failover Strategies Review & Cheat Sheet
06 Extensions 5
PostGIS Geospatial TimescaleDB: Time-Series Citus: Distributed SQL Module Review: Extensions
Courses / postgres

Advanced PostgreSQL

Advanced PostgreSQL Last updated: Feb 27, 2026

Learn about Advanced PostgreSQL with interactive visualizations and depth. Learn the core concepts through interactive visualizations, deep-dive proofs, and pr.

Course Modules

Module 01 Available

Advanced SQL

Learn about Advanced SQL with interactive visualizations and depth. Learn the core concepts through interactive visualizations, deep-dive proofs, and productio.

Explore Module
Module 02 Available

Indexing Strategies

Learn about Indexing Strategies with interactive visualizations and depth. Learn the core concepts through interactive visualizations, deep-dive proofs, and pr.

Explore Module
Module 03 Available

Query Performance Tuning

Master Postgres Query Performance: Execution Plans, Join Strategies, and Statistics. Learn the core concepts through interactive visualizations, deep-dive proo.

Explore Module
Module 04 Available

Concurrency & Locking

Master PostgreSQL concurrency control. Learn how MVCC works, the implications of different isolation levels, and how to use explicit locking to prevent data ...

Explore Module
Module 05 Available

Replication & HA

Learn about Replication & HA with interactive visualizations and depth. Learn the core concepts through interactive visualizations, deep-dive proofs, and produ.

Explore Module
Module 06 Available

Extensions & Internals

Learn about Extensions & Internals with interactive visualizations and depth. Learn the core concepts through interactive visualizations, deep-dive proofs, and.

Explore Module
A Dev Writes

Engineering excellence for the modern developer. Master System Design, Algorithms, and more with professional-grade content.

Learn

All Courses System Design DSA

Resources

Learning Paths About

Legal

Privacy Policy Terms of Service

© 2026 A Dev Writes. All rights reserved.