Engineering writeups and incident post-mortems for #postgresql.
Articles: 6In-depth engineering analysis: Post-mortem: PostgreSQL connection leak in background worker pool during upstream timeouts. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: Vector embeddings search in PostgreSQL: pgvector tuning and IVFFlat vs HNSW indexing. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: Zero-downtime database schema migrations: the Expand and Contract pattern in practice. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: PostgreSQL performance cliff caused by Transparent Huge Pages (THP). Practical diagnostics, logs and production configuration.
In-depth engineering analysis: PostgreSQL connection starvation: PgBouncer transaction mode pitfalls with prepared statements. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: PostgreSQL autovacuum freeze storm: production downtime due to transaction ID wraparound. Practical diagnostics, logs and production configuration.
