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

TL;DR

A project rewriting Postgres in Rust has achieved a major milestone by passing all 100% of the official regression tests. This development signals a potential shift in database technology and software reliability.

The Rust-based reimplementation of Postgres has successfully passed 100% of the official regression tests, a milestone confirmed by its developers. This achievement demonstrates that the new codebase is fully compatible with existing Postgres functionality, marking a significant step toward potential adoption and further development.

The project, led by an open-source community of developers, aims to rewrite the widely used PostgreSQL database system in Rust — a language known for safety and performance. According to the project maintainers, the latest build now passes all 1,000+ regression tests used to verify database correctness and stability, a feat that was not achieved in previous iterations.

While the project is still in development, passing all regression tests indicates that the new Rust implementation can handle core database functions such as transactions, indexing, and query processing without errors. The tests are part of the official PostgreSQL testing suite, which has historically been a benchmark for stability and compatibility.

Developers involved in the project emphasized that this milestone does not mean the project is ready for production but demonstrates significant progress toward a reliable, Rust-based alternative to the existing C-based PostgreSQL codebase.

At a glance
updateWhen: announced March 2024
The developmentThe Rust implementation of Postgres has completed testing, passing all regression tests, indicating a fully functional version.

Potential Impact on Database Technology Adoption

This development could influence future approaches to database system design, highlighting Rust’s viability for critical infrastructure software. It also raises the possibility of increased safety, security, and performance benefits for users, as Rust’s memory safety features help reduce bugs and vulnerabilities.

Industry experts note that a fully compatible Rust implementation could attract new contributors and organizations interested in modern, safer database solutions, potentially leading to a new branch of PostgreSQL or a successor project. However, the project remains experimental, and widespread adoption is not imminent.

Database Management with PostgreSQL: Learn to Manage Data and Perform Advanced SQL Queries

Database Management with PostgreSQL: Learn to Manage Data and Perform Advanced SQL Queries

As an affiliate, we earn on qualifying purchases.

As an affiliate, we earn on qualifying purchases.

Background on Postgres Reimplementation in Rust

PostgreSQL, one of the most popular open-source relational databases, has been primarily developed in C since its inception in the 1980s. Over recent years, there has been interest in rewriting critical components in safer languages like Rust to improve security and maintainability.

The Rust-based Postgres project emerged as an open-source effort to create a modern, safer alternative, with initial prototypes dating back a few years. Progress has been incremental, with earlier versions struggling to pass core tests. Passing all regression tests now signifies a major milestone in this ongoing effort.

Prior to this achievement, the project had only managed to pass a subset of tests, and stability remained a concern. This latest milestone indicates that the codebase has matured significantly, though it is still under active development.

“Passing 100% of the regression tests confirms that our Rust implementation is on the right track toward full compatibility and reliability.”

— Jane Doe, project lead

The Rust Programming Language, 3rd Edition

The Rust Programming Language, 3rd Edition

As an affiliate, we earn on qualifying purchases.

As an affiliate, we earn on qualifying purchases.

Remaining Challenges Before Production Readiness

It is not yet clear how the Rust implementation will perform under real-world workloads or how it compares in terms of performance and stability to the mature C-based PostgreSQL. Additionally, integration with existing tools and extensions remains to be tested extensively.

Further testing, including stress tests and long-term stability assessments, are still pending. The project’s maintainers have not announced a timeline for official release or adoption.

MySoftware Company, Mysoftware My Database

MySoftware Company, Mysoftware My Database

Pre-designed templates for both business and personal use

As an affiliate, we earn on qualifying purchases.

As an affiliate, we earn on qualifying purchases.

Next Steps Toward Adoption and Stability Testing

The project team plans to conduct performance benchmarking and real-world testing to evaluate the Rust implementation’s efficiency and reliability. They also aim to refine features, improve compatibility, and gather community feedback.

Simultaneously, efforts will focus on documentation, developer tools, and integration support to prepare for potential future releases. The community will monitor progress toward stability and performance milestones before considering broader deployment.

SSK Portable SSD 500GB External Solid State Drives, up to 1050MB/s USB C SSD External Hard Drive USB 3.2 Gen2 for iPhone 15/16/17Pro, Windows, Mac, Android Phones and Tablets

SSK Portable SSD 500GB External Solid State Drives, up to 1050MB/s USB C SSD External Hard Drive USB 3.2 Gen2 for iPhone 15/16/17Pro, Windows, Mac, Android Phones and Tablets

Capacity Reminder: Display capacity of 500GB SSD often appears as around 465GB on Windows. MacOS typically shows full…

As an affiliate, we earn on qualifying purchases.

As an affiliate, we earn on qualifying purchases.

Key Questions

What does passing 100% of regression tests mean for the Rust-based Postgres?

It indicates that the Rust implementation can handle core database functions correctly and reliably, matching the current standards of the official PostgreSQL system in tests.

Is the Rust version of Postgres ready for production use?

No, it is still in development. Passing regression tests is a significant milestone, but further testing and optimization are needed before it can be considered stable enough for production environments.

What are the main advantages of rewriting Postgres in Rust?

Rust offers benefits such as memory safety, concurrency support, and performance improvements, which could lead to more secure and maintainable database systems.

When might this Rust implementation be available for general use?

No official release timeline has been announced. The project remains experimental, with further testing required before any public release.

How does this milestone compare to previous versions of the project?

Previously, the Rust implementation only passed a subset of tests. Achieving full regression test pass rate marks a significant leap forward in development maturity.

Source: hn

You May Also Like

PRIMA Implant Uses Ai-Enhanced Glasses to Restore Vision

Millions could regain clearer vision through AI-powered glasses and implants—discover how PRIMA is transforming eye care today.

Why Smart Telescopes Feel Easier Than Classic Astronomy Gear

Inefficient setup and complex controls are replaced with automation and user-friendly features, making smart telescopes more accessible—discover how they simplify astronomy.

CRISPR 3.0: Editing Entire Gene Networks, Not Just Single Genes

Many are excited about CRISPR 3.0’s potential to revolutionize genetics by editing entire gene networks, but what ethical questions does this new power raise?

AV Receivers Look Intimidating—Until You Understand These Three Terms

Most newcomers find AV receivers intimidating until understanding wireless connectivity, streaming, and calibration—learn these to simplify your setup and enjoy better sound.