Skip to content

Wikantik

Where information goes to live.

Tagged

pgvector

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.

Diagram linking POSIX Markdown storage, BM25 plus pgvector hybrid retrieval, and dual read/admin MCP servers

The Wikantik Reader's Field Guide: How Storage, Hybrid Search, and Dual MCP Fit Together

· Technology · 4 min read

A guided tour through Wikantik's 19 engineering posts—connecting POSIX Markdown storage, BM25 + pgvector hybrid search, and dual MCP servers.

Systems architecture blueprint illustrating the removal of an extracted entity knowledge graph in favor of high-density vector embeddings and a deterministic page link graph

Why We Clobbered the Knowledge Graph: Search Ranking Realities and Architecture Simplification in Wikantik

· Technology · 7 min read

Why Wikantik deleted 70,500 lines of Knowledge Graph code: empirical search ranking failure, operational latency, and the power of dense vector retrieval.

Technical architectural blueprint of Wikantik post-fork showing the tri-tier storage engine, dual MCP gateways, and React interface

Beyond the Fork: Settling the Architecture of an Agent-Grade Knowledge Base

· Technology · 4 min read

An engineering analysis of Wikantik's tri-tier storage architecture, dual MCP protocol gateways, and post-fork stabilization objectives.

Technical architectural schematic of hybrid retrieval merging Lucene BM25 keyword search and pgvector dense semantic embeddings via Reciprocal Rank Fusion

Building the Hybrid Retrieval Engine: BM25 Meets pgvector and Reciprocal Rank Fusion

· Technology · 4 min read

How Wikantik unified Lucene BM25 keyword search with PostgreSQL pgvector dense embeddings using heading-aware chunking and Reciprocal Rank Fusion.