{"id":632437,"date":"2026-10-16T13:14:12","date_gmt":"2026-10-16T13:14:12","guid":{"rendered":"https:\/\/www.newsbeep.com\/nz\/632437\/"},"modified":"2026-10-16T13:14:12","modified_gmt":"2026-10-16T13:14:12","slug":"postgres-19-delayed-after-ai-reviewers-find-more-bugs-than-humans-can-fix","status":"publish","type":"post","link":"https:\/\/www.newsbeep.com\/nz\/632437\/","title":{"rendered":"Postgres 19 delayed after AI reviewers find more bugs than humans can fix"},"content":{"rendered":"

<\/p>\n

\n databases\n <\/p>\n

<\/a><\/p>\n

\n Core devs revert up to 10 features, push release to November, and blame better tooling rather than vibe coding\n <\/p>\n

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. <\/p>\n

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.<\/p>\n

Explaining the number of reverts \u2014 features whose rollouts have now been postponed to next year’s release, PostgreSQL 20 \u2014 Peter Eisentraut, veep at\u00a0EDB, a PostgreSQL support and consultancy, said the reason could be at least in part attributed to the LLM code reviews used by developers. <\/p>\n

In a blog post,<\/a> 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.”<\/p>\n

However, the introduction of LLM-assisted code review also uncovered a long tail of \u201crelatively harmless issues involving various edge cases\u201d which, in past times, developers might not have noticed until much later, most likely issuing bug fixes in the five years following launch. \u201cWith LLM-assisted code review, these kinds of things can get found much faster, and then you\u2019re 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.\u201d<\/p>\n

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. <\/p>\n

\u201cThe 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,\u201d Eisentraut said. <\/p>\n

He was also at pains to point out that the reverts were not down to \u201cvibe coding\u201d in development, as the technique was not available when most of the new features were written. <\/p>\n

Postgres was first proposed<\/a> 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. <\/p>\n

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.<\/p>\n

At the time, PostgreSQL contributor Tom Lane warned<\/a>: “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.”<\/p>\n

Despite the delay, Eisentraut promises PostgreSQL 19 will still be \u201ca great release,\u201d that includes\u00a0REPACK CONCURRENTLY, which avoids the table-lock VACUUM FULL operation used to reclaim disk space. <\/p>\n

\u201cAnd it will be very robust, after all the additional scrutiny,\u201d he said. <\/p>\n

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.\u00ae<\/p>\n","protected":false},"excerpt":{"rendered":"databases Core devs revert up to 10 features, push release to November, and blame better tooling rather than…\n","protected":false},"author":2,"featured_media":632438,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[365,363,364,111,139,69,145],"class_list":["post-632437","post","type-post","status-publish","format-standard","has-post-thumbnail","category-artificial-intelligence","tag-ai","tag-artificial-intelligence","tag-artificialintelligence","tag-new-zealand","tag-newzealand","tag-nz","tag-technology"],"_links":{"self":[{"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/posts\/632437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/comments?post=632437"}],"version-history":[{"count":0,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/posts\/632437\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/media\/632438"}],"wp:attachment":[{"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/media?parent=632437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/categories?post=632437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newsbeep.com\/nz\/wp-json\/wp\/v2\/tags?post=632437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}