SQLAlchemy + Postgres Cheatsheet 16 — VACUUM, Bloat, and Maintenance
Cheatsheet: autovacuum settings, manual vacuum, finding bloat, REINDEX CONCURRENTLY, table stats.
Postgresql
SQLAlchemy + Postgres Cheatsheet 17 — pg_stat_statements and Slow Queries
Cheatsheet: enable pg_stat_statements, find top queries, auto_explain, slow-query log via SQLAlchemy events.
SQLAlchemy + Postgres Cheatsheet 18 — Backup, PITR, and Restore
Cheatsheet: pg_dump, pgBackRest, WAL archiving, PITR, restore testing.
SQLAlchemy + Postgres Cheatsheet 19 — Operational Patterns
Cheatsheet: PgBouncer config, app vs admin roles, statement_timeout, max_connections, scaling tactics.
SQLAlchemy + Postgres Cheatsheet 20 — Useful Postgres Extensions
Cheatsheet: pg_stat_statements, pg_trgm, citext, uuid-ossp, pgvector, pgcrypto, pg_partman, hypopg, pg_repack.
Postgres as a Queue in 2026 — Boring, Reliable, Underrated
Practical Postgres-backed queues: SKIP LOCKED for concurrency, LISTEN/NOTIFY for low-latency wake-up, retries, dead-letter, and when to graduate to Kafka.
Postgres Locking in 2026 — Row Locks, Advisory Locks, and Avoiding Deadlocks
Practical Postgres locking: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, isolation levels, and how to debug locking problems.
Postgres JSONB in 2026 — Indexing, Querying, and When to Stop
Practical Postgres JSONB: GIN indexes, jsonb_path queries, partial indexes, when to denormalize vs normalize, and the perf gotchas.
Postgres Partitioning in 2026 — When, Why, and How to Not Regret It
Production Postgres partitioning: range / list / hash, when partitioning helps vs hurts, pg_partman automation, and pitfalls with foreign keys and indexes.
Postgres Replication Topologies in 2026 — Streaming, Logical, and the Tradeoffs
Choosing a Postgres replication topology: streaming for HA, logical for upgrades / cross-cluster, cascading for fanout, and pitfalls in each.