Tagged
pgvector
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 Wikantik Reader's Field Guide: How Storage, Hybrid Search, and Dual MCP Fit Together
A guided tour through Wikantik's 19 engineering posts—connecting POSIX Markdown storage, BM25 + pgvector hybrid search, and dual MCP servers.
Why We Clobbered the Knowledge Graph: Search Ranking Realities and Architecture Simplification in Wikantik
Why Wikantik deleted 70,500 lines of Knowledge Graph code: empirical search ranking failure, operational latency, and the power of dense vector retrieval.
Beyond the Fork: Settling the Architecture of an Agent-Grade Knowledge Base
An engineering analysis of Wikantik's tri-tier storage architecture, dual MCP protocol gateways, and post-fork stabilization objectives.
Building the Hybrid Retrieval Engine: BM25 Meets pgvector and Reciprocal Rank Fusion
How Wikantik unified Lucene BM25 keyword search with PostgreSQL pgvector dense embeddings using heading-aware chunking and Reciprocal Rank Fusion.