Webtagr - Technology News Summarizer

Popular：

Virtualization DNS security formal verification reachability analysis compiler errors macro conflict web extension development framework Bitmap Graphics API inconsistencies All Tags

OrioleDB: A High-Performance PostgreSQL Storage Extension

2025-07-19

OrioleDB is a PostgreSQL storage extension that replaces the default Heap storage engine, dramatically improving performance. By redesigning core components like MVCC, page caching, and checkpoints, OrioleDB enhances throughput and predictability for transactional workloads while maintaining the familiar PostgreSQL user experience. Recent releases add support for non-B-tree index types, tablespaces, and fillfactor, along with query and index performance optimizations. Benchmarks using TPC-C and sysbench show significant throughput improvements over PostgreSQL's default Heap engine, with go-tpc tests demonstrating multiple times the tpmC.

Development

OrioleDB's Bridged Indexes: Balancing Speed and Ecosystem

2025-05-30

OrioleDB introduces bridged indexes, a clever solution to integrate PostgreSQL's rich ecosystem of non-B-tree indexes (like GIN, GiST) while preserving its MVCC-aware, heap-free architecture. A virtual `iptr` column and a lightweight bridge index map PostgreSQL indexes to OrioleDB's internal structure. This allows support for diverse index types. While adding a slight query overhead (one extra lookup), this cost is often negligible for complex indexes (e.g., pg_vector's ANN search). This innovation lets users leverage their preferred extensions without sacrificing performance.

Development index