Postgres rewritten in Rust, now passing 100% of the Postgres regression tests • Hacker News Board

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#521

Post by imhoguy » Fri, Jul 10, 2026, 7:25 AM UTC

cyphar wrote: post #351

pyrolistical wrote: post #256

Earlier quoted context omitted.

It’s open source. You take ownership of it for your deployment and stop relying on continued free work. You can use llm to pull in updates as they are released. It’s not gpl, so you don’t need to publish your port

1. Nobody, not even the Googles or NSAs of the world do that. No single entity has the expertise nor resources necessary to maintain a fork for every open source project they use -- forking and maintaining Linux alone takes teams of people. And no, going full psychosis mode with LLMs is not going to save you. 2. This project is AGPLv3.

Except Amazon (Linux, Elastic, RDS..)

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#522

Post by egorfine » Fri, Jul 10, 2026, 7:29 AM UTC

cyphar wrote: post #351

pyrolistical wrote: post #256

Earlier quoted context omitted.

It’s open source. You take ownership of it for your deployment and stop relying on continued free work. You can use llm to pull in updates as they are released. It’s not gpl, so you don’t need to publish your port

1. Nobody, not even the Googles or NSAs of the world do that. No single entity has the expertise nor resources necessary to maintain a fork for every open source project they use -- forking and maintaining Linux alone takes teams of people. And no, going full psychosis mode with LLMs is not going to save you. 2. This project is AGPLv3.

> going full psychosis mode with LLMs is not going to save you

People in AI psychosis don't know that.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#523

Post by langs » Fri, Jul 10, 2026, 7:33 AM UTC

juliangmp wrote: post #2

I feel like we need to heavily differentiate between a rewrite and an AI rewrite.

nope. any rewrite will be an AI rewrite soon.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#524

Post by codingjoe » Fri, Jul 10, 2026, 7:34 AM UTC

Given that you reuse Postgres' tests and LLM have been clearly trained on Postgres' three decades of contributions, this may constitute a license violation. Unless you include the original license of course. From a human level I also understand how you ended up with a less permissive license.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#525

Post by up2isomorphism » Fri, Jul 10, 2026, 7:35 AM UTC

It is very bad metric to measure a rewrite using the original tests. It is like to say you clone a cat by mimic 600 cat images.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#526

Post by PeterStuer » Fri, Jul 10, 2026, 7:35 AM UTC

Let's hope it did not special case (overfit) for the specific tests. One of the failiure modes that in my experience takes the most effort to mitigate for.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#527

Post by preisschild » Fri, Jul 10, 2026, 7:37 AM UTC

processunknown wrote: post #360

____tom____ wrote: post #356

Earlier quoted context omitted.

Yeah. I'm gonna have an LLM rewrite Star Wars and then film it. Should be fine, right?

LGTM. copyright laws don't matter anymore.

Only for the billion $ LLM companies that pay dear leader

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#528

Post by diarrhea » Fri, Jul 10, 2026, 7:38 AM UTC

f311a wrote: post #469

levkk wrote: post #296

Earlier quoted context omitted.

Ouf. I don't know. I don't want to call you out without evidence -- I myself make benchmark claims all the time -- but 50% improvement in OLTP seems suspicious. I get that you used a standard benchmark, and I don't even know what it entails, but my spidey sense is going off. Perhaps, some trade off somewhere that won't make it to prod because it breaks MVCC -- and yes, I saw that it passes regression tests. Just chec…

Yeah, claims that it can be faster than CH are very suspicious. CH guys are very good at their craft, they spend hundreds of hours optimizing one single small detail.

Yeah. I don't think PG could even come close. Column-oriented is fundamentally different, and pairs well with all the SIMD acceleration ClickHouse is also doing. There's just no comparison. If a Postgres rewrite came close to that, it must've sacrificed something else.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#529

Post by preisschild » Fri, Jul 10, 2026, 7:38 AM UTC

moi2388 wrote: post #464

processunknown wrote: post #360

Earlier quoted context omitted.

LGTM. copyright laws don't matter anymore.

The only good thing to come out of AI.

How is this good? Copyleft licenses are also being ignored.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#530

Post by HPsquared » Fri, Jul 10, 2026, 7:38 AM UTC

jarym wrote: post #451

HPsquared wrote: post #170

Earlier quoted context omitted.

In that case they need to document the process and workflow, and demonstrate the care that was taken.

Quite amusing we have decades of human written code much of it sub standard and yet no one demanded proof till now of Open Source projects having to ‘demonstrate’ anything. If ya don’t wanna use it, don’t. Simple.

Maybe the principal maintainer can be trusted, but pull requests could do with some of that evidence.