Show HN: OrioleDB Beta12 Features and Benchmarks
orioledb.comHey HN, I'm the creator of OrioleDB, an extension for PostgreSQL that serves as a drop-in replacement for the default Heap storage engine. It is designed to address scalability bottlenecks in PostgreSQL's buffer manager and reduce the WAL, enabling better utilization of modern multi-core CPUs and high‑performance storage systems.
We are getting closer to GA. This release includes:
- An index bridge to support all indexes that Heap supports
- Support for rewinding recent changes in the database.
- Tablespaces support
- Fillfactor support
- An orioledb_tree_stat() function for space utilization statistics
- Support for tables with more than 32 columns.
We also show several performance improvements using the TPC-C benchmarks. Overall, OrioleDB is much faster than Heap, also outperforming other Postgres providers.
We would love more people testing OrioleDB. The fastest way to do that is to use the docker image provided:
docker run -d --name orioledb -p 5432:5432 orioledb/orioledb
Hopefully this will be part of the official Postgres soon(ish), along with what Planetscale is doing we could finally have an Open Source SQL DB system that is powerful without too much customisation.
Additionally, OrioleDB beta12 features a new fastpath tree search, which can accelerate workloads with intensive key-value lookups by up to 20%. Stay tuned for a new blog post about this later this week.
Does it require core patches or I can install it into the standard upstream Postgres? Asking because, afaik, it did, but it might that something has changed already.
It still requires some patches to the Table Access Method API which have been submitted upstream:
https://www.orioledb.com/docs#patch-set
Awesome. How far away would you say are you from a stable orioledb as postgres extension?
Great! How does it fit into the landscape?
Can i used it in conjunction with other extensions, like the recently announced pgactive from amazon?
pgactive uses logical replication so it should be compatible OOTB
one of the possible enhancements Oriole could enable is multi-master (in the presentation here: https://www.orioledb.com/docs#solving-postgresql-wicked-prob...), although that work will come later. The focus for now is getting to GA so that it can be used instead of Heap
Great work!!