Running a lightweight retrieval pipeline (pgvector + 3-pass agentic RAG) in production for a self-hosted AI memory tool — architecture notes
8/10This article presents a detailed architecture for a production-grade lightweight retrieval-augmented generation (RAG) pipeline using self-hosted Supabase Postgres with pgvector for vector similarity search, combined with a 3-pass agentic retrieval method and Gemini API embeddings (768 dimensions). The system balances latency and retrieval quality to support an AI memory tool, showcasing practical deployment notes on embedding storage, query efficiency, and pipeline orchestration.
