I always wondered why sequence numbers weren't replicated, it added another step to the stress of upgrading via pg_backup but thanks for adding it to PG19!
Personally I would say, for critical production systems, its still good to wait for the .1 release.
Part of why delaying is helpful is that more people will actually install the release than they do during the beta/RC cycle, and (in my read) most of the delay of the release was not necessarily because of significant bugfixing of features that remained in 19 (though e.g. REPACK certainly had its fair share of fixes), but rather the Postgres committers being overly busy with some of the security fixes that just went into 18.7 and the other minors, combined with some late removals of features that warranted an extra beta and RC release.
> Part of why delaying is helpful is that more people will actually install the release than they do during the beta/RC cycle
Unless everybody starts waiting for .1 :)
> was not necessarily because of significant bugfixing in 19
They discovered some serious bugs in new features which weren't really solvable in a way the devs were comfortable with (with regards to long-term maintainability and stability). So some of the new features were rolled back and that process also took some time.
Yep, agreed its bad if everyone does it - but e.g. you could upgrade pre-prod / staging and only do prod once the 19.1 release is out.
To clarify what I meant with the second part: If you look at e.g. SQL/PGQ it was reverted pretty late (beta4), but that revert doesn't mean that other features don't have bugs that are yet to be ironed out. e.g. just this morning a bugfix went in that can crash EXPLAIN (BUFFERS) (without ANALYZE) when you have auto_explain turned on [0]. Edge case, but could happen, and the fix will only be in 19.1 in February 2027.
A huge thank you to all contributors for this gift
I always wondered why sequence numbers weren't replicated, it added another step to the stress of upgrading via pg_backup but thanks for adding it to PG19!
This is the most bug-free .0 release of Postgres. I am always waiting for at least .1 or .2 before upgrading. But should I wait this time?
Personally I would say, for critical production systems, its still good to wait for the .1 release.
Part of why delaying is helpful is that more people will actually install the release than they do during the beta/RC cycle, and (in my read) most of the delay of the release was not necessarily because of significant bugfixing of features that remained in 19 (though e.g. REPACK certainly had its fair share of fixes), but rather the Postgres committers being overly busy with some of the security fixes that just went into 18.7 and the other minors, combined with some late removals of features that warranted an extra beta and RC release.
> Part of why delaying is helpful is that more people will actually install the release than they do during the beta/RC cycle
Unless everybody starts waiting for .1 :)
> was not necessarily because of significant bugfixing in 19
They discovered some serious bugs in new features which weren't really solvable in a way the devs were comfortable with (with regards to long-term maintainability and stability). So some of the new features were rolled back and that process also took some time.
Yep, agreed its bad if everyone does it - but e.g. you could upgrade pre-prod / staging and only do prod once the 19.1 release is out.
To clarify what I meant with the second part: If you look at e.g. SQL/PGQ it was reverted pretty late (beta4), but that revert doesn't mean that other features don't have bugs that are yet to be ironed out. e.g. just this morning a bugfix went in that can crash EXPLAIN (BUFFERS) (without ANALYZE) when you have auto_explain turned on [0]. Edge case, but could happen, and the fix will only be in 19.1 in February 2027.
[0]: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...
You probably should install it in a test environment. Waiting won't do you any good, if there are load-specific bugs.
Congrats to everyone who worked on this release!
Earlier: https://news.ycombinator.com/item?id=50560357
Found Previous Leon!