Home server RAG search built using Postgres pgvector

The author built a local retrieval-augmented generation server on a home machine using Postgres, pgvector, and a local model to search tens of thousands of private documents without sending data to third parties. The system combines vector and full-text search with reciprocal rank fusion and a cross-encoder reranker to answer questions with citations while enforcing local-only privacy constraints. Open article →