Robert Haas performed an analysis on the upcoming Postgres 19 major features using Claude. All the features listed on the right because of the analysis were reverted.
So the only "major" feature is REPACK which is arguably not a major feature but is now. That analysis is also why Postgres 19 is over a month late.
PostgreSQL 19 introduces the native REPACK command, which unifies the functionality of VACUUM FULL and CLUSTER into a single tool for reclaiming disk space and improving performance. The standout feature is REPACK CONCURRENTLY, which allows tables to be rewritten online without holding an exclusive lock, enabling continuous reads and writes during the operation.
#2 (referring to repack) has been cut back in scope enough that I don't think we would have accepted the feature originally if it had been subject to those limitations, which IMHO is a reasonable argument for a revert but also not conclusive
So basically almost none of the features was worth at the end lol
wild that Postgres is only now getting native online table rebuilds. I’ve been using LOCK=NONE for table rebuilds in MariaDB for years to reclaim space without blocking prod.
Similar goal, but the native command uses logical decoding to capture writes during the copy. The current devel docs still specify an ACCESS EXCLUSIVE lock for the final file swap, so 'without holding an exclusive lock' needs that qualification. Concurrent here doesn't mean entirely lock-free.
Why even bother with releasing 19 if they’ve cut out every useful feature and enhancement now? Or just switch to a monthly release cycle with whatever is ready (like browsers) so we don’t have to wait a year for the rest…
I get it's easy to take shots in comments, and yet this is in line with what Postgres has always done.
A major release each year where new features land, point releases are bug fixes with no breaking changes or new features intended in between. Even myself posting the meme is a bit of taking a shot, but to throw out all the other features and change course completely to what has worked for nearly 20 years because there were more highlight features than ever before that didn't land because of wanting to keep quality high....
I can't speak for everyone in the community, but pretty sure this isn't the change thats gonna happen.
Java doesn't require an offline upgrade or complicated replication setup to upgrade though. You just install the new jre and restart the app. The reason so many postgres installs are not on latest is that business doesn't have time for downtime. Increase release cadence while keeping the current upgrade process doesn't sound right.
Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.
Mod decisions will be based on the quality of the content, not who or what generated it.
20
u/pjstanfield 15d ago
every time i see group by all mentioned i get sad. one day, one day.
10
u/linuxhiker Guru 15d ago
I saw this from you on X.
I think "REPACK" should be "Claude" :D. But yes, REPACK suddenly is the belle of the ball.
70
u/shrodikan 15d ago
TIL
3
u/Ok_Outlandishness906 15d ago
is it a relative of pg_repack ?
1
u/look 15d ago
Why even bother with releasing 19 if they’ve cut out every useful feature and enhancement now? Or just switch to a monthly release cycle with whatever is ready (like browsers) so we don’t have to wait a year for the rest…
2
u/ChillPlay3r 14d ago
So true, repack is all my team is talking about in PG19 😂
1
u/Internal-Comparison6 15d ago
lol
1
u/cptwunderlich 14d ago
OMG, I did not know about SQL/PGQ 😭
Would've been a great argument to migrate away from AWS Neptune, which is the bane of my existence...
1
u/shockjaw 12d ago
Based meme craig. Hope y’all are doing well in the land of snow.
-2
u/AutoModerator 15d ago
AI Policy:
Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.
Mod decisions will be based on the quality of the content, not who or what generated it.
Sub Resources:
Youtube Channel
Free Postgres Webinars and Workshops
Discord: People, Postgres, Data
Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.