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
Tag: postgresql
Blog posts filed under tag postgresql.
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.