5 min read
The Postgres-only AI stack
pgvector for embeddings, LISTEN/NOTIFY for jobs, row-level security for isolation. One database instead of four services, until you need more.
3 posts tagged vector-search.
pgvector for embeddings, LISTEN/NOTIFY for jobs, row-level security for isolation. One database instead of four services, until you need more.
Dense embeddings and BM25 catch different failures. Reciprocal rank fusion in pgvector, and when pure vector search is still the right call.
A practical comparison of pgvector, Pinecone, Qdrant, and Weaviate — real cost and latency numbers from production, and why pgvector is usually enough to start.