I am curious about OrioleDB given my unsuccessful attempts to resolve some Postgres perf issues for the Insert Benchmark via tuning.
The first step is to compile and install their Postgres fork from source.
git checkout patches16_18
bash mk.pg.o3_native_lto ~/d/pg16oriole
make USE_PGXS=1 install
make USE_PGXS=1 installcheck
There is a test failure during make installcheck (see issue 275) but that doesn't matter to me today. I am not trying to use this in production.
The next step is to modify my Postgres init scripts so I can use OrioleDB. I lack many basic PG admin skills and stumbled my way through the locales issue. I hope OrioleDB updates their README to explain that.
# shared_preload_libraries = 'orioledb.so'
# Add this to my init scripts.
# First make the test database use the C locale because OrioleDB
bin/createdb ib -l "C" -T template0
The final step is to modify my benchmark clients to create OrioleDB tables and that is done by appending using orioledb to the end of the CREATE TABLE statements.