2 min read
Why vector similarity alone falls short: PostgreSQL FTS, pgvector, and RRF
Why dense embeddings miss exact technical tokens, and how to fuse PostgreSQL full-text search with pgvector cosine similarity using RRF in SQL.
WRITING / BLOG
Blog
Engineering write-ups on PostgreSQL query optimization, hybrid retrieval with pgvector and RRF, and deterministic agent verification.
4 min read
The day I sped up a slow Postgres query by 40x
Tracing high buffer reads in EXPLAIN ANALYZE and replacing a misordered index with a partial composite index to cut latency from 480ms to 11ms.