orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)
What is orioledb?
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)
Overview of orioledb
What it is
OrioleDB is a cloud-native storage engine for PostgreSQL, implemented as an extension using the table access method framework. It aims to address several well-known PostgreSQL limitations, such as CPU bottlenecks on multi-core servers, transaction ID wraparound, and table bloat. OrioleDB is designed for modern hardware including SSDs and NVRAM, and its architecture supports distributed deployments with row-level write-ahead logging. As of the README, OrioleDB is in public beta status and is recommended for experimentation and testing, not for production use.
Key features
- No buffer mapping and lock-less page reading, improving vertical scalability on many-core systems.
- MVCC based on an undo log concept, eliminating bloat and the need for dedicated VACUUM processes.
- Copy-on-write checkpoints providing structurally consistent snapshots and friendly to modern SSDs.
- Row-level write-ahead log with parallel apply, optimized for raft consensus-based replication and planned active-active multimaster.
- Default 64-bit transaction identifiers, eliminating the transaction ID wraparound problem.
- Page merging to reclaim space from deleted tuples without dedicated garbage collection.
Use cases
- Cloud-native PostgreSQL deployments requiring efficient use of modern hardware.
- High-concurrency workloads that benefit from lock-less page reading and reduced CPU contention.
- Environments where minimizing maintenance overhead (e.g., VACUUM) is critical.
- Future active-active multimaster replication scenarios (planned).
- Testing and benchmarking of next-generation storage engine features.
Getting started
bash # Pull the Docker image docker pull orioledb/orioledb:latest-pg17 # Run a container (set locale to C or POSIX) docker run --name some-postgres -e POSTGRES_PASSWORD=... -e POSTGRES_INITDB_ARGS='--locale=C' -d -p5432:5432 orioledb/orioledb:latest-pg17 After starting PostgreSQL, enable the extension and create tables: sql CREATE EXTENSION orioledb; CREATE TABLE table_name (...) USING orioledb; For building from source, see the repository README for detailed instructions including patched PostgreSQL requirements.
License and pricing
OrioleDB is dual-licensed under the Apache License 2.0 and the PostgreSQL License. It is open source and free to use. A separate patent grant is provided by Supabase (see PATENTS.txt in the repository).
Based on the project's public README and repository metadata.