PostgreSQL 19 RC 1 Lands as GA Slips to November 19
PostgreSQL 19 RC 1 shipped October 15, but general availability moved to November 19 with a second release candidate. What was reverted, what stayed, and what to test before you upgrade.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL 19 RC 1 shipped October 15, but general availability moved to November 19 with a second release candidate. What was reverted, what stayed, and what to test before you upgrade.
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 — […]