Postgres SQLAlchemy Textbook Ch. 10 — Replication, Failover, and pgvector
Streaming replication, read replica routing, failover handling in SQLAlchemy, and using pgvector for embeddings.
Pgvector
SQLAlchemy + Postgres Cheatsheet 12 — pgvector (Embeddings)
Cheatsheet: vector column, HNSW vs IVFFlat, cosine / L2 / inner-product distance, RAG hybrid filter.
pgvector Deep Dive — HNSW, IVFFlat, and Tuning Postgres for Vector Search
Everything you need to make pgvector fast in production: HNSW vs IVFFlat, distance operators, m and ef_construction, ef_search at query time, partial indexes for multi-tenant data, and benchmarking your real workload.
Build a Production RAG App with pgvector and FastAPI in 2026
A complete, end-to-end RAG backend built on PostgreSQL + pgvector and FastAPI. Real chunking, real embeddings, hybrid (vector + BM25) retrieval, prompt assembly, citations, and production gotchas.