Hacker News new | ask | show | jobs
by jeltz 610 days ago
Yeah, upgrading to PostgreSQL 17 now would be weird unless you have some very specific feature you need in it and spent resources testing your application on the betas and rcs.
1 comments

My team has upgraded several dozen databases from 16.x to 17.3. Went entirely smoothly. The thing is that we're running on a process of upgrading all dependencies every Friday, and then promoting to prod on Monday unless there are specific issues, so our definition of "would be weird" is the reverse from what you say.

(Granted, we have rather small DBs and simple applications where ON UPDATE SKIP LOCKED is about the most fancy feature we use.)

Be careful if you use streaming replication - secondary replica leaks memory on 17.0 (16.4 is fine)
17.3? That doesn't exist (yet).
Oh sorry, I went from memory and mixed up the numbers in "16.3 -> 17.0".