Do I still have to use pg_upgrade when I'm just upgrading from RC-1?
git diff REL_16_RC1..REL_16_0 doesn't show any changes that would require a pg_upgrade (at least from my read), so you should be able to upgrade without it.
PostgreSQL 16
11–20 of 89 posts
Re: PostgreSQL 16
#12> Add SQL/JSON constructors and identity functions This will be a nice quality of life addition!
> SQL/JSON constructors
Like these?
> Adds SQL/JSON constructors, including JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG().
Not sure what SQL/JSON identity functions relate to
Re: PostgreSQL 16
#13anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…
[flagged]
schools either never worked or stopped working. after all, look, almost all the people who went to school don't give a fuck about underperforming underfunded school systems. (or healthcare or ... or if they care they are ignorant and clueless about what to do with the problem, and easily fell prey to political dogma of some group.)
it's simply time to stop worrying about it.
Re: PostgreSQL 16
#14anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…
[flagged]
Re: PostgreSQL 16
#15> Add SQL/JSON constructors and identity functions This will be a nice quality of life addition!
> SQL/JSON constructors Like these? > Adds SQL/JSON constructors, including JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG(). Not sure what SQL/JSON identity functions relate to
identity probably refers to the ’IS’:
SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array w/o UK?" FROM (VALUES ('[{"a":"1"}, {"b":"2","b":"3"}]')) foo(js);
Re: PostgreSQL 16
#16Earlier quoted context omitted.
[flagged]
schools either never worked or stopped working. after all, look, almost all the people who went to school don't give a fuck about underperforming underfunded school systems. (or healthcare or ... or if they care they are ignorant and clueless about what to do with the problem, and easily fell prey to political dogma of some group.) it's simply time to stop worrying about it.
The people underfunding our schools had their private schooling paid for by virtue of being unconscionably wealthy.
The more you realise what has happened the more maddeningly upset you will get, so it's best not to think about it.
Sufficed to say: you're wrong, additionally: dead wrong and it's not relevant for a topic about databases.
Re: PostgreSQL 16
#17anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…
[flagged]
if they're getting more than $200 then it's already way more money than I think.
It's true that there is some money (after all, there is pgcon); and it's true that some people are paid to work on postgresql.
However: it's additionally true that there are many volunteers, and that it's free for us to use, modify, hack on and so forth.
coordinating that effort must be absolutely herculean.
Re: PostgreSQL 16
#18Earlier quoted context omitted.
[flagged]
schools either never worked or stopped working. after all, look, almost all the people who went to school don't give a fuck about underperforming underfunded school systems. (or healthcare or ... or if they care they are ignorant and clueless about what to do with the problem, and easily fell prey to political dogma of some group.) it's simply time to stop worrying about it.
School systems are not underfunded. They're underperforming despite being overly funded. We're throwing good money after bad.
Re: PostgreSQL 16
#19anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…
They significantly increased major versions frequency, transition from 9 to 10 took 7 years, and now they release major version every year.
Re: PostgreSQL 16
#20anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…
They significantly increased major versions frequency, transition from 9 to 10 took 7 years, and now they release major version every year.
They just changed the versioning scheme; it used to be that e.g. 9.3 -> 9.4 was a major version (i.e. can't be upgraded in-place). Starting with PG 10 major versions are now 10 -> 11, etc. I don't believe the major release cadence itself changed that much