We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Practical use case for OrioleDB - Alexander Korotkov & Aliaksei Ramanau - PGCon 2022
Discover OrioleDB, a modified PostgreSQL core addressing 5 of the 10 wicked problems, with a hybrid storage engine, improved performance, and reduced storage space, now in production at Wargaming.
- OrioleDB is a modified PostgreSQL core that addresses 5 of the 10 wicked problems listed in a popular blog post about Postgres.
- OrioleDB uses a hybrid storage engine that combines a log-structured merge tree with a hybrid index, which improves performance and reduces storage space.
- The project aims to provide a new database core that resolves long-term problems in PostgreSQL.
- OrioleDB has shown promising results in performance tests, with higher TPS and fewer IOPS compared to PostgreSQL.
- The project is being used in production at Wargaming, which uses it to store a large amount of data for its gaming platform.
- OrioleDB has a unique feature called a “page merging” mechanism that improves storage space efficiency.
- The project also includes a module for sharding, which allows for horizontal scaling and easier maintenance.
- The OrioleDB architecture eliminates many bottlenecks and provides better performance and scalability on modern hardware.