pgBackRest 2.60: Page Checksum Errors and How to Survive Them
pgBackRest 2.60.0 makes invalid page checksums a hard error on restore and expire. A step-by-step tutorial to find corruption before a restore does.
Month: 6 hours ago
pg_hint_plan 1.9.0: Plan Stability on the Way to Postgres 19
pg_hint_plan 1.9.0 is the first release built on PostgreSQL 19’s path generation strategies. How to inventory your hints, test hinted versus unhinted plans, and delete the ones that no longer earn their keep.
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.
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.
PostgreSQL 19 RC 1: An Ops Plan to Rehearse pg_upgrade Now
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.
How to Bulk Load Data into PostgreSQL with COPY
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.
PgBouncer vs RDS Proxy: Picking a Postgres Pooler in 2026
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 […]
Postgres News: JDBC CVE Patch, Citus Query Routers
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: Block Runaway Postgres Queries by Cost
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.
Postgres Transparent Data Encryption: pg_vault_tde 1.7.2
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.