#postgresql
6 posts
PostgreSQL-specific posts — query plans, index types, vacuum, and how the server actually executes your SQL.
Postgres Concurrency Internals: Connections, Locks, and MVCC
A practical guide to how Postgres handles many concurrent clients — process-per-connection, pooling, lock manager, MVCC tuples, deadlocks, and pg_locks.
postgresqldatabaseconcurrencyinternalsperformance
Database Replication: Strategies, Topologies, and What to Use When
A practical guide to PostgreSQL replication — physical vs logical, sync vs async, single-leader / multi-leader / leaderless, and replica-read rules.
postgresqldatabasedistributed-systemsreplicationarchitecture
Postgres Partitioning: Strategies, Real Advantages, and Pitfalls
A practical guide to PostgreSQL partitioning — RANGE, LIST, HASH, pruning, local indexes, real advantages, and the pitfalls that bite in production.
postgresqldatabaseperformanceinternals
Sharding Postgres: When One Database Stops Being Enough
Sharding PostgreSQL at scale — shard keys, routing, distributed transactions, online rebalancing, and the 15 complexities every team eventually hits.
postgresqldatabasescalingarchitecturedistributed-systems
PostgreSQL Indexing: Internals, Types, and Trade-offs
A practical guide to PostgreSQL indexes: B-tree, GIN, GiST, BRIN, hash — when to use each, composite key ordering, and CONCURRENTLY pitfalls.
postgresqldatabaseperformanceinternals
PostgreSQL EXPLAIN: Reading and Understanding Query Plans
How to read PostgreSQL EXPLAIN output: scan types, join algorithms, and the cost model — turn opaque query plans into actionable insights.
postgresqldatabaseperformancesql