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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/orioledborioledb.svg)](https://yunodb.com/tools/orioledborioledb?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/orioledborioledb?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/orioledborioledb.svg" alt="Featured on YunoDB" height="20"></a>