Postgres Vector Indexes 2026: HNSW, DiskANN, or No Graph?
HNSW, StreamingDiskANN, and a new partition-plus-compression design: how to pick a Postgres vector index, fix filtered search, and keep it in RAM.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL on this site is the main hub for everything related to designing, running, and improving modern Postgres databases. It brings together practical guidance on performance tuning, real‑world architecture patterns, learning resources, and hands‑on examples so developers and DBAs can get more out of PostgreSQL in production. From book recommendations and beginner tutorials to deep dives into scaling, extensions, and advanced features, this category is where readers go to level up every aspect of their Postgres stack.
HNSW, StreamingDiskANN, and a new partition-plus-compression design: how to pick a Postgres vector index, fix filtered search, and keep it in RAM.
Release candidate 1 is out and GA lands November 19. A five-week ops plan to rehearse pg_upgrade, replication cutover and rollback before production sees it.
COPY vs \copy, staging tables, ON_ERROR handling, load-speed tuning, and verification: a step-by-step guide to loading millions of rows into Postgres.
Postgres runs out of connections long before it runs out of CPU. The classic shape: an application fleet scales from 12 pods to 60 for a morning peak, each pod holding a 10-connection pool, and an instance comfortable at 120 backends is suddenly carrying 600. No query got worse; everything got slower. Every backend is […]
PostgreSQL JDBC 42.7.14 patches two CVEs that touch every JVM service on Postgres, plus Citus query routers in StackGres 1.19, pgNimbus 1.0, and the October community calendar.
pg_plan_filter 1.0.0 refuses Postgres statements whose estimated plan cost is too high. How to install it, choose limits, and cap runaway batch work.
pg_vault_tde 1.7.2 shipped a new on-disk format and a WAL resource-manager ID change that rules out a rolling upgrade. An operations runbook for Postgres transparent data encryption: config, upgrade steps, key rotation, backups and monitoring.
pgx-bm25 1.0 puts Okapi BM25 ranking into a native Postgres index access method. Build it, index a table, and run ranked, boolean, proximity and snippet queries step by step.
If your Postgres dashboard runs REFRESH MATERIALIZED VIEW on a schedule, you know the ritual: for a few seconds, readers queue behind a lock while the database recomputes a result it mostly already had. The fix is not a faster refresh. It is not refreshing at all. pg_ivm — the Incremental View Maintenance extension — […]
Pgpool-II patched seven CVEs across five branches on October 1. Plus: Aurora queries Iceberg directly, Supabase buys Turso, pgEdge launches Starfleet, and Dasha 1.8 ships index recommendations.