Tagged
database
Zero-Downtime Schema and pgvector Index Migrations on Live PostgreSQL
How to evolve PostgreSQL tables and pgvector HNSW indexes in production without tripping lock queues, starving connection pools, or spilling graph builds to disk.
Surviving the N+1 Storm: Database Profiling and Statement Pruning
Tracing N+1 statement amplification in Wikantik's JDBC layer and the refactoring that collapsed thousands of round-trips into constant-time queries.