Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
Embeddings search is no longer a novelty feature; it is table stakes for Postgres teams building RAG pipelines, semantic search, and recommendation engines. pgvector, the open-source extension that adds vector columns and nearest-neighbor search to PostgreSQL, is where most of those teams start. The current v0.8.x line supports Postgres 13 and later, with single-precision, half-precision, […]
On August 13, 2026 the PostgreSQL Global Development Group released 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3. If you run logical replication, manage pg_upgrade plans, or operate in FIPS-enforced environments, this is not a routine minor release — two of the security fixes change runtime behavior in ways that can break production after […]
You added the index. You waited for the CREATE INDEX to finish. You re-ran the query. And EXPLAIN still shows a Seq Scan. The query is still slow. If that sounds familiar, you are not alone — it is one of the most common performance questions Houston DBAs bring up in tuning sessions. Before you […]
