Skip to content

Wikantik

Where information goes to live.

Tagged

database

Architecture diagram of zero-downtime PostgreSQL and pgvector HNSW dual-index migration pipeline

Zero-Downtime Schema and pgvector Index Migrations on Live PostgreSQL

· Technology · 8 min read

How to evolve PostgreSQL tables and pgvector HNSW indexes in production without tripping lock queues, starving connection pools, or spilling graph builds to disk.

Database profiling dashboard contrasting cascading N+1 query waterfalls against batched constant SQL statements

Surviving the N+1 Storm: Database Profiling and Statement Pruning

· Technology · 4 min read

Tracing N+1 statement amplification in Wikantik's JDBC layer and the refactoring that collapsed thousands of round-trips into constant-time queries.