hiw3c 日报精选
Hacker News Top 网页快照

人工智能审查员发现人类无法修复的错误数量后,Postgres 19被推迟

原文标题 · Postgres 19 delayed after AI reviewers find more bugs than humans can fix

HN Ÿ 8 · 0 评论

来源:Hacker News Top · www.theregister.com

正文为英文,可一键机器翻译(仅首次需要等待)

Postgres 19 delayed after AI reviewers find more bugs than humans can fix

Core devs revert up to 10 features, push release to November, and blame better tooling rather than vibe coding

READ MORE

Open source sovereignty gets down to the boring business of making it work 7 hours ago

KDE hits 30, decides it's time to move out of the X11 era 1 day ago

Linux kernel devs drop obligatory confession of AI tool usage 1 day ago

New motherboards, old RAM, plenty of life left in yesterday's PCs 2 days ago

When you just need to build a tiny desktop app: TinyJS 4 days ago

The PostgreSQL Global Development Group has delayed the release of PostgreSQL 19, the latest iteration of the popular open source database, and held back an unusual number of features.

Once slated for release in late September or early October, PostgreSQL 19 is now expected to be generally available around November 19. Developers have also dropped between eight and 10 significant features.

Explaining the number of reverts — features whose rollouts have now been postponed to next year's release, PostgreSQL 20 — Peter Eisentraut, veep at EDB, a PostgreSQL support and consultancy, said the reason could be at least in part attributed to the LLM code reviews used by developers.

In a blog post, Eisentraut, who is a leading PostgreSQL committer, said some of the reverted features had significant architectural defects that would have been hard to fix "quickly and during beta."

However, the introduction of LLM-assisted code review also uncovered a long tail of “relatively harmless issues involving various edge cases” which, in past times, developers might not have noticed until much later, most likely issuing bug fixes in the five years following launch. “With LLM-assisted code review, these kinds of things can get found much faster, and then you’re staring at a list of forty defect reports. Even if each of them requires only a three-line fix on average, there is a fixed overhead to dealing with each of these, and then you run out of time.”

When the big updates for PostgreSQL 19 were written, LLM-assisted code review was not as useful as it is now, we're told, but in the months leading up to the launch, the AI-supported reviews became better understood and more effective.

“The effective quality bar has been raised after the time the feature was written and committed. Unless the capabilities of LLM-assisted code review keep improving at the current rate, this situation should sort itself out for future development cycles,” Eisentraut said.

He was also at pains to point out that the reverts were not down to “vibe coding” in development, as the technique was not available when most of the new features were written.

Postgres was first proposed by Michael Stonebraker in 1986. In 1994, Andrew Yu and Jolly Chen replaced the query language POSTQUEL with SQL, and in 1995 made the database freely available and modifiable under a more permissive license, renaming it PostgreSQL. It has since become the most popular database among professional developers owing to the services the big three hyperscalers built on it as well as the range of wire-compatible distributed systems available.

Among the features pulled from the PostgreSQL 19 iteration is support for SQL Property Graph Queries (SQL/PGQ), which became part of the SQL standard in 2023. The feature provides syntax for exploring relationships between nodes connected by edges. PostgreSQL's implementation was removed over unresolved issues.

At the time, PostgreSQL contributor Tom Lane warned : "At this point I'd be willing to bet dinner that if we ship it in v19 there will be post-release bug discoveries that are unfixable until v20."

Despite the delay, Eisentraut promises PostgreSQL 19 will still be “a great release,” that includes REPACK CONCURRENTLY , which avoids the table-lock VACUUM FULL operation used to reclaim disk space.

“And it will be very robust, after all the additional scrutiny,” he said.

The features reverted from PostgreSQL 19 will likely make it into PostgreSQL 20. Just a few months ago, developers expected PostgreSQL 20 to have no new features, just bug fixes. Now, it is likely to have the new features left over from the earlier release, Eisentraut said.®

New online tool will check lawyers' sloppy AI-written briefs since they can't seem to be bothered

Bogus AI-generated citations keep turning up in court documents, but lawyers could at least run those docs through this legal citation checker

Networking problems after the October 2026 Windows update? NTLM might be to blame

Legacy protocol is going to be axed, and enforcement by default will highlight how migration is going

When faster supercomputers aren’t enough

PARTNER CONTENT: A million reasons why advanced computing matters for genomics

NTT Global Data Centers weighs the price tag of not building fast enough

SPONSORED POST: As AI hunger soars, NTT Global Data Centers finds it's permits, not parts, that could cap the datacenter boom

It won't kill you, or humanity, to get off the AI upgrade treadmill

New models arrive so fast, we already have more new tech than it's possible to understand in a career

Uncle Scam Wants You … to cough up your cash and personal data, FBI warns ahead of midterms

The inevitable election-themed cyberattacks are whirring again, as the feds issue PSA about the ones to watch out for

TOP STORIES

Anthropic asks users to stop being mean to Claude

PWNED US Air Force pilots used malware-laden USB drives to plan Afghanistan missions

'123456' password linked to Denmark data breach affecting 8.8M people

Microsoft and Anthropic play invoice tennis with startup's $17,600 Claude bill

Shai-Hulud worm makes jump to AI infrastructure with Tensorlake compromise

Exclusive KPMG tech and data boss tells staff facing the boot he's getting promoted

AI

Want your AI chats to stay private? Brave TEEs up end-to-end encryption Browser maker using trusted hardware to protect conversations with GLM 5.3 Flash

$24,000 AI experiment ports TypeScript compiler to Rust Microsoft's Go rewrite gets some competition, with a developer claiming his port runs twice as fast

TSMC sends scouts to check whether America's datacenters can deliver Silicon giant budgets up to $64B for expansion while keeping an eye on construction progress and power supplies

Linux kernel devs drop obligatory confession of AI tool usage Torvalds says contributors must understand their code, whatever tools they use

Researchers cig-nal their faith in AI by taking up smoking What are they puffing? Tobacco, apparently. Cancer researcher tells El Reg it's a bad bet

Infosec

Security Russians are posing as Signal support to launch phishing attacks PLUS: US takes down Iranian propaganda sites; Marketing company asks 'Why Do We Have Your Information?' And more!

Security Microsoft patches failed to fix on-prem SharePoint, which is now under zero-day attack PLUS: China upgrades smartphone surveillance tools; Ring eases anti-snooping stance; and more

Black Hat and DEF CON DEF CON Franklin project enlists hackers to harden critical infrastructure Voting village reports have been so successful, says Jeff Moss, that the whole of DEF CON will now be included

Security EQT buys majority share in Swiss cybersecurity biz Acronis Went at equivalent of $3.5B+ valuation for entire firm, though portion sold not specified

Malware Month Ten years since the first corp ransomware, Mikko Hyppönen sees no end in sight On the plus side, infosec's a good bet for a long, stable career

FOSS

NetBSD may have found a new role: The AI-free FOSS OS Increasing awareness and adoption, followed by increasing donations

OpenAI dots inspire open source imitators amid technical difficulties Persistent agents appeal to AI companies, but demand isn't obvious

Ubuntu 'Stonking Stingray' beta swims out: Deeper Rust 'oxidization' plus LLM speech-to-text GNOME 51 is here, and Ubuntu interim releases are getting interesting again

Revive Raskin's 3 laws of software with humane work that considers a dev's duty of care All this, and angry NeoVim users

Firefox 157: Could bold new look be just what Mozilla needs?* Yet another new version of Firefox, with a significant reskin

KDE turns 30 and someone's brought an AI-native desktop proposal Akademy talk imagines Plasma assembling itself around a personal model of each user