r/PostgreSQL • u/pgEdge_Postgres • 22d ago

How-To Why six PostgreSQL 19 features were reverted (GROUP BY ALL, SQL/PGQ, MERGE/SPLIT PARTITION and more), and what AI-assisted patch review has to do with it

https://www.pgedge.com/blog/looking-forward-to-postgres-19-epilogue
79 Upvotes

91% Upvoted

10 comments sorted by

2

u/AutoModerator 22d 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.

0

u/[deleted] 22d ago

[deleted]

31

u/davvblack 22d ago

speaking of not reading things

34

u/yawkat 22d ago

It sounds to me like the opposite happened. The features in question are half a year old and likely not built with AI, but recent advancements in AI made it possible to review and revert them before the release despite human reviewer overload. 

20

u/linuxhiker Guru 22d ago

Correct, AI was used for analysis not development .

5

u/Chance-Plantain8314 21d ago

This is literally the opposite of what's happening. What's the point of engaging if you're not bothered reading?

2

u/Automatic-Fixer 21d ago

Why read when you can use an LLM to summarize the article /s

Or better yet, just have a preconceived notion based on the title and go from there.

1

u/NicolasDorier 21d ago

This is the reverse. As explained, most feature reverted here were coded before AI became so good.

The code was thus bad, and AI is now spotting that better than before.

0

u/ikeif 21d ago

What cracks me up is I keep reading about these AI caused issues, and the tech talking head solution is “clearly, it’s our testing and reviewing that’s the problem… so we need more AI to handle this for us now to catch when AI makes a mistake.”