Since our last public update, OrioleDB has continued to evolve with a series of new releases. These updates refine the core engine, extend functionality, and improve performance across a range of workloads. Together, they move us closer to a beta release and lay the groundwork for broader adoption.
OrioleDB is a PostgreSQL storage extension that implements a custom Table Access Method as a drop‑in replacement for the default Heap storage engine. It is designed to address scalability bottlenecks in PostgreSQL’s buffer manager and reduces the WAL, enabling better utilization of modern multi-core CPUs and high‑performance storage systems.
By rethinking core components such as MVCC, page caching, and checkpoints, OrioleDB improves throughput and predictability in transactional workloads without altering PostgreSQL’s user-facing behavior.
Building on this foundation, recent releases have introduced several user-facing enhancements:
Support for non‑ B-tree index types on OrioleDB tables.
index types on OrioleDB tables. Support for rewinding recent changes in the database.
Support for tablespaces.
fillfactor support for OrioleDB tables and indexes.
support for OrioleDB tables and indexes. orioledb_tree_stat() SQL function for space utilization statistics.
SQL function for space utilization statistics. Support for tables with more than 32 columns.
... continue reading