Egres: a new Postgres-compatible database
A ground-up database design aimed at combining Postgres wire compatibility with multi-tenant resource metering, an LSM-forest storage engine, object-storage support, and zero-copy branching. The author publishes detailed comparative benchmarks, while noting the current release is single-node with basic query support.
Manish Jain introduces Egres, a new database that speaks the Postgres protocol but is not a Postgres fork. Its design targets heavy, multi-tenant workloads: a coroutine-based execution system meters CPU, memory, and disk I/O per query and tenant; its zdb storage engine is an LSM forest; and it supports local or object storage, Raft-based replication, and instant zero-copy database or table branches.
The author reports results from a 600-million-row comparison with Postgres 18, including lower disk use and faster results on several read queries. These are the author’s benchmark results, not an independent evaluation; the linked methodology page describes the setup. The trade-offs are material: the current release is single-node, query support is basic (equality predicates, no joins), and its load rate was slower in the reported test. The post says multi-node clustering is planned for a later release.