Christophe Pettus: On pgvectorscale, and Hybrid Search Without an Elasticsearch Sidecar

pgvector is excellent. It is also, at large scale, expensive — because the HNSW index it gives you wants to live in memory to be fast, and “wants to live in memory” stops being a casual statement...