Hacker News new | ask | show | jobs
by Narkov 610 days ago
> Postgres 17.0 has been out for a bit

From the same blog:

> Sep 26, 2024 - Postgres 17 is Now Available

3 weeks....for a new major release...and we are asking ourselves why people haven't updated?

1 comments

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.
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".