OrioleDB fastpath search (faster random key lookups for PostgreSQL) (opens in new tab)

(orioledb.com)

4 pointsakorotkov8mo ago1 comments

1 comments

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: fastpath search, an inter-page search that bypasses page copying and tuple deformation for certain fixed-length datatypes.

We would love for more people to test and benchmark OrioleDB. You can check how fastpath search would help your workload. The fastest way to do that is to use the Docker image provided:

    docker run -d --name orioledb -p 5432:5432 orioledb/orioledb

j / k navigate · click thread line to collapse

1 comments

akorotkovOP8mo ago

This blog post is dedicated to describing a new OrioleDB optimization: fastpath search, an inter-page search that bypasses page copying and tuple deformation for certain fixed-length datatypes.

We would love for more people to test and benchmark OrioleDB. You can check how fastpath search would help your workload. The fastest way to do that is to use the Docker image provided:

    docker run -d --name orioledb -p 5432:5432 orioledb/orioledb

j / k navigate · click thread line to collapse