Hybrid search in PostgreSQL with pgvector: chunk-level embeddings, reciprocal rank fusion SQL, filtered ANN scans, and how to measure recall before you ship.
I've been going down the LSM / databases-on-object-storage rabbit hole and wanted to see for myself why almost nobody runs an HNSW graph straight off a bucket.…