Tagged
postgresql
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.
The Unfinished Roadmap: Horizontal Scale, PgBouncer, and What Wikantik Still Needs
Architectural analysis of Wikantik's single-host operating boundaries, the prerequisites for horizontal scaling with PgBouncer, and section-level Knowledge Graph reranking.
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.