Evaluate Profile-Guided Optimization (PGO) #4
Description
Hi!
Recently I checked Profile-Guided Optimization (PGO) improvements on multiple projects. The results are here.
Since PGO showed measurable improvements in database-like loads (MySQL, MariaDB, PostgreSQL and many others) I think it could be useful to check PGO on PostgreSQL as well. I already did some benchmarks on PostgreSQL - the results are here.
I think you can re-check my results and if it works for you too - write a note about optimization PostgreSQL with PGO somewhere in the OrioleDB documentation.
PGO also could help with optimizing https://github.com/orioledb/orioledb/ itself, since according to my tests PGO helps to the projects like SQLite and RocksDB.