[HN Gopher] Show HN: OrioleDB Beta12 Features and Benchmarks
       ___________________________________________________________________
        
       Show HN: OrioleDB Beta12 Features and Benchmarks
        
       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 release includes:  - An
       index bridge to support all indexes that Heap supports  - Support
       for rewinding recent changes in the database.  - Tablespaces
       support  - Fillfactor support  - An orioledb_tree_stat() function
       for space utilization statistics  - Support for tables with more
       than 32 columns.  We also show several performance improvements
       using the TPC-C benchmarks. Overall, OrioleDB is much faster than
       Heap, also outperforming other Postgres providers.  We would love
       more people testing OrioleDB. The fastest way to do that is to use
       the docker image provided:                   docker run -d --name
       orioledb -p 5432:5432 orioledb/orioledb       Read the full release
       here:  https://www.orioledb.com/blog/orioledb-beta12-benchmarks
        
       Author : akorotkov
       Score  : 51 points
       Date   : 2025-07-15 12:22 UTC (4 days ago)
        
 (HTM) web link (www.orioledb.com)
 (TXT) w3m dump (www.orioledb.com)
        
       | akorotkov wrote:
       | Additionally, OrioleDB beta12 features a new fastpath tree
       | search, which can accelerate workloads with intensive key-value
       | lookups by up to 20%. Stay tuned for a new blog post about this
       | later this week.
        
       | jfbaro wrote:
       | Great work!!
        
       | kabes wrote:
       | Awesome. How far away would you say are you from a stable
       | orioledb as postgres extension?
        
       | ololobus wrote:
       | Does it require core patches or I can install it into the
       | standard upstream Postgres? Asking because, afaik, it did, but it
       | might that something has changed already.
        
         | kiwicopple wrote:
         | It still requires some patches to the Table Access Method API
         | which have been submitted upstream:
         | 
         | https://www.orioledb.com/docs#patch-set
        
       | znpy wrote:
       | Great! How does it fit into the landscape?
       | 
       | Can i used it in conjunction with other extensions, like the
       | recently announced pgactive from amazon?
        
         | kiwicopple wrote:
         | pgactive uses logical replication so it should be compatible
         | OOTB
         | 
         | one of the possible enhancements Oriole could enable is multi-
         | master (in the presentation here:
         | https://www.orioledb.com/docs#solving-postgresql-wicked-
         | prob...), although that work will come later. The focus for now
         | is getting to GA so that it can be used instead of Heap
        
       | ksec wrote:
       | Hopefully this will be part of the official Postgres soon(ish),
       | along with what Planetscale is doing we could finally have an
       | Open Source SQL DB system that is powerful without too much
       | customisation.
        
         | kiwicopple wrote:
         | we (supabase) are developing an open source vitess adaptation
         | fwiw
         | 
         | https://supabase.com/blog/multigres-vitess-for-postgres
        
       | rickette wrote:
       | Would Postgres FTS (ts_vector) benefit from this storage engine?
        
       ___________________________________________________________________
       (page generated 2025-07-19 23:02 UTC)