Overview
pgrust is an ambitious project to rewrite the PostgreSQL database engine in Rust. It achieves remarkable compatibility, successfully passing 100% of the extensive PostgreSQL regression tests. This rewrite aims to enhance PostgreSQL's internal architecture, making it more amenable to modification and exploration of advanced server features, all while maintaining the robustness and behavior of the original.
Key Features
- Full PostgreSQL Regression Test Pass: pgrust now matches PostgreSQL's expected output across over 46,000 regression queries, signifying a significant milestone in compatibility and correctness.
- Disk Compatibility with Postgres 18.3: Seamlessly boot from an existing PostgreSQL 18.3 data directory, enabling smooth transitions and easier testing.
- Rust-Powered Architecture: Leverages Rust's safety and performance benefits for a modern database engine.
- AI-Assisted Development: Employs AI to explore and implement deeper server changes, accelerating development and innovation.
- Early Performance Gains: A newer, unreleased version demonstrates significant performance improvements, including a thread-per-connection model, 50% faster transaction workloads, and dramatically faster analytical workloads (approaching ClickHouse performance).
- Browser Demo Available: Experience pgrust directly through a live web demo.
Typical Use Cases
While not yet production-ready, pgrust is ideal for:
- Database Developers and Researchers: Exploring fundamental database internals and experimenting with advanced features in a safe and modern language.
- Performance Enthusiasts: Investigating and contributing to next-generation database performance optimizations, particularly for analytical workloads.
- Early Adopters: Testing cutting-edge database technology and providing feedback to shape its future development.
- PostgreSQL Internals Learners: Gaining a deeper understanding of PostgreSQL's architecture through its Rust implementation.
