Ordered Insertion Optimization in OrioleDB

https://www.orioledb.com/blog/batch-inserts

by akorotkov • 11 months ago

19 1 11 months ago

akorotkov• 11 months ago

Hey 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 blog post is dedicated to describing a new OrioleDB optimization: ordered insert optimization. When multiple processes are trying to insert into the same page, the first one that grabs the lock does the job for the others. That dramatically cuts the locker waiting time and thus improves the overall throughput. This is very critical for IoT, time series and others.

We would love for more people to test and benchmark OrioleDB. You can check how ordered insertion optimization would help your workload. The fastest way to do that is to use the Docker image provided (please note you need to use a specific tag):

    docker run -d --name orioledb -p 5432:5432 orioledb/orioledb:ordered-inserts-pg17

Ordered Insertion Optimization in OrioleDB

Related Stories