Show HN: OrioleDB Beta12 Features and Benchmarks
10 months ago
- #Benchmarking
- #PostgreSQL
- #Database Performance
- OrioleDB is a PostgreSQL storage extension designed to replace the default Heap storage engine, improving scalability and performance.
- Recent updates include support for non-B-tree indexes, tablespaces, and tables with more than 32 columns.
- Performance improvements include sparse file support, optimized undo logs, and faster B-tree navigation.
- Benchmarks show OrioleDB outperforming PostgreSQL's Heap storage in TPC-C and sysbench tests.
- TPC-C benchmark results indicate significant throughput improvements with OrioleDB across various instance sizes.
- Sysbench tests show OrioleDB achieving ~19,000 QPS compared to ~9,500 QPS with Heap storage.
- OLTP benchmarks reveal OrioleDB's superior performance in read-heavy workloads, averaging ~37,000 QPS.
- OrioleDB can be easily started using a provided Docker image.