A curated roundup of PostgreSQL content covering: scaling vector search to 1 billion vectors using VectorCord on a single machine; a retrieve-and-rerank approach using BM25 plus semantic search without requiring a vector index; unconventional PostgreSQL optimizations including constraint exclusion, function-based indexes, and hash-based exclusion constraints; a 40x performance boost for LISTEN/NOTIFY via shared hash tables in a potential Postgres 19 commit; a deep dive into underestimated merge join plans caused by dead tuple index marking; ALTER TABLE behavior on partitioned tables; Supabase's Postgres best practices docs for LLMs; a Kubernetes vs VM decision guide for PostgreSQL; serial-to-bigint migration guidance; PostgreSQL contributor stats; and a new realistic workload simulation tool from PGEdge.