Indexing

PostgreSQL JSONB Advanced Patterns — Indexing, Performance, and Pitfalls

JSONB beyond the basics — GIN with jsonb_path_ops, partial and expression indexes, generated columns for hot fields, partitioning, jsonb_set rewrites, and the mistakes that turn 12ms queries into 4 seconds.

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.