pgvector: Add Vector Search to Postgres
Use pgvector to run embeddings, similarity search, and hybrid retrieval inside Postgres. Schemas, indexes, and a working Python pipeline.
·4 min read · #pgvector#postgres#intermediate
#postgres
2 posts.
Postgres EXPLAIN and Practical Query Tuning
Learn how to read Postgres EXPLAIN and EXPLAIN ANALYZE output, spot expensive operations, and apply practical indexing and rewrite techniques to speed up queries.
·6 min read · #postgres#performance#intermediate