Skip to content

Wikantik

Where information goes to live.

Tagged

postgresql

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.

Systems architectural roadmap schematic contrasting single-host Docker limits with a future distributed architecture featuring PgBouncer and horizontal clustering

The Unfinished Roadmap: Horizontal Scale, PgBouncer, and What Wikantik Still Needs

· Technology · 4 min read

Architectural analysis of Wikantik's single-host operating boundaries, the prerequisites for horizontal scaling with PgBouncer, and section-level Knowledge Graph reranking.

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.