Articles for people who
ship the stack
Rewrites on React, Node.js, TypeScript and AI. A translated body is shown when it exists. If it does not, you see the English text and a note that says so.
Tagged: pgvector
Moving RAG From Pinecone to Postgres pgvector: Six Months Later
Moving RAG from Pinecone to Postgres pgvector, six months on: 9M vectors, real cost, latency and recall numbers, what got worse, and when pgvector is right.
7 min readHybrid Search in Postgres for a Health Assistant: Schema, Chunking, RRF and Evals
Hybrid search in Postgres for a health assistant: structure-aware chunking, pgvector with RRF, binary quantization, score thresholds and a proper evaluation.
19 min readFive Ways to Index Vectors for RAG, Tested on a Million Wikipedia Embeddings
Five ways to index vectors for RAG tested on a million Wikipedia embeddings: flat, IVFFlat, HNSW, BM25 hybrid and DiskANN, with latency and recall numbers.
9 min readChoosing a Vector Database for RAG: Eight Options Compared
Compare Chroma, Milvus, Qdrant, Weaviate, pgvector, Pinecone, Turbopuffer and TiDB on scale, filtering, cost and operations, plus where vector RAG falls short.
12 min readAegisOps: An Autonomous SRE Agent With Four Memory Layers
How a LangGraph ReAct agent resolves Kubernetes incidents, with pgvector episodic memory, policy-gated autonomy levels, sixteen tools and a full audit trail.
12 min readBM25 Plus pgvector With Reciprocal Rank Fusion: Hybrid Search for RAG in Python
Hybrid search for RAG in Python: why dense retrieval misses exact terms, how BM25 and pgvector cosine search complement each other, fused with RRF on Postgres.
8 min readSemantic Search in PostgreSQL With pgvector and Node.js, No LLM Needed
Semantic search in PostgreSQL with pgvector and Node.js, no LLM: MiniLM embeddings, chunks, an IVFFlat index, distance operators and how to read the scores.
8 min readCustomer Memory for AI Agents Under a Strict Token Budget
How an agent memory layer extracts facts, scores importance, dedupes at 0.92 cosine, stores vectors in pgvector, and retrieves within a 2,048-token cap with eviction.
8 min readSemantic Search in PostgreSQL With pgvector and .NET: A Practical Setup
Store embeddings next to relational data, build HNSW or IVFFlat indexes, filter and blend hybrid ranks, and judge when pgvector is enough for your app.
9 min read
About these articles
Request a 24h estimate
Need the same stack in a production operator layer? Send the brief — estimate within 24 hours.