Evaluate Profile-Guided Optimization (PGO)

[zamazan4ik]

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.

[bapho-bush]

Any updates?