Get the latest tech news
Why does everyone run ancient Postgres versions?
Many companies are running old Postgres versions and missing out on many improvements. The reasons: Postgres works and upgrades suck.
Retool used Warp for parallel processing to expedite the initial dump and restore, while Knock created custom publications and subscriptions for incremental migration. They compared row counts and sample data between old and new databases, ran load tests to verify performance, and conducted multiple dry runs in staging environments. Part of the lack of inspiration around upgrading comes from the hassle of manually comparing release notes between versions and figuring out how many improvements you’re missing.
Or read this on Hacker News