PostgreSQL 19's data checksums can now be switched on without stopping the server

DEV Community·12 points·alexgeorgiev17·9 days ago·dev.to

I measured PostgreSQL 19 beta's online checksum conversion against the old offline tool: roughly 1.3s of hard downtime the old way versus 2.8s of background work and 799MB of extra WAL the new way, with zero drop in concurrent write throughput.

Read the full article at dev.to →

#postgresql #without #server #19s #checksums #stopping #data #switched

Related stories

Show HN: Beyond "chat with your database" – agentic data explorationreportr.com
Hacker News · 1 points · about 10 hours ago
Show HN: Datastory, Data storytelling with AI and an open knowledge graphdatastory.tech
Hacker News · 6 points · about 9 hours ago
Show HN: I-server: Hide server using ICMP reflection/Destination Unreachablegithub.com
Hacker News · 4 points · 11 days ago
Show HN: Capsule – Single-file web apps that save their data into SQLitewithcapsule.app
Hacker News · 377 points · 16 days ago
Google's first Suncatcher orbital data center test launches October 1arstechnica.com
Ars Technica · 0 points · 6 days ago
Google fined €403M by Irish data watchdog over location datarte.ie
Hacker News · 3 points · 10 days ago

Related topics

databases40 postgres50 database56 node28 server92 point28 monitoring15 saas25 linux196 19s3 free199