PostgreSQL 19 was released today. pgEdge packages for it are available the same day across all of our supported deployments - including Spock, where PG 19 support is already available. I have been testing the release candidates for a few weeks, so here is what I think matters most to DBAs and teams. replaces and , and with the option it rebuilds a bloated table without blocking reads and writes. In my own test, inserts kept running at about 2,000 a second with no failed transactions while a bloated table was rebuilt in under a second. It needs a primary key or replica identity index, and it is not MVCC safe for transactions that started before the swap. Shaun Thomas wrote a blog on the topic - give it a read for more detail. gets the biggest changes for anyone running replicated clusters. Sequences can now be published with and synced with , which removes the manual step from migrations and upgrades. Logical replication can also be turned on without a restart when is replica. Subscriptions get for better conflict detection, and publications can leave tables out with ., autovacuum can now use parallel workers on indexes and ranks tables with a scoring system, so the ones that need it most go first. The and extensions let you steer the planner and keep a plan you trust. The new command gives read-your-writes consistency on standbys. are worth knowing. is faster on text and CSV input, can now write JSON, and lets a load continue past bad values. For monitoring, is now on by default, there is a new view, and the wraparound warning now starts at 100 million transactions instead of 40 million.
Backend
Ahsan Hadi: PostgreSQL 19 is Here: Worth the Wait
Planet PostgreSQL0 views
Source:https://postgr.es/p/9CT
PreviousApple’s head of camera and Photos software has retired, per reportNextBlockchain system could secure cross-border renewable energy and carbon certificate trade
Related posts

I Built a Ghibli-Style Mughal-Tudor Palace With World Labs Atlas (Chisel). Here's What It Can Do for 3D, Games and Video
0dev.to AI
177 views, 0 sales: the verdict fired — and what changed next
0dev.to AI
Your Terraform IAM Policies Are Haunted (Here's How I Exorcised Them with Kiro)
0dev.to AWS
How to Trim Audio for an Amber Lake Video — Free, in Your Browser
0dev.to WebDev
The Java4Shell fix lives in the fourth version number
0dev.to WebDev
What a Garry's Mod Backdoor Actually Looks Like (and How to Spot One)
0dev.to Security