pgrust

pgrust is a re-implementation of PostgreSQL written entirely in Rust. It aims to maintain wire and SQL dialect compatibility with Postgres and has passed the full Postgres regression suite. The project focuses on modernizing the database architecture to improve performance and reliability. Key technical capabilities include: - A vectorized, push-based, JIT-compiled executor (specifically tuned for Graviton4). - A thread-based concurrency model and a query scheduler to prevent individual queries from destabilizing the database. - A built-in OOM killer to manage memory limits and prevent OS-level crashes. - pgrcolumnar: A built-in column-oriented storage layout with dictionary encoding and compression. - Pipelined fsync to improve performance for highly contended updates. Currently, pgrust is not production-ready and does not support existing PostgreSQL extensions. It is available as a WebAssembly version for browser testing, as binaries for macOS and Linux, and as a Docker image.