Evaluate using Profile-Guided Optimization (PGO) and LLVM BOLT

[zamazan4ik]

Is your feature request related to a problem? Please describe.
Not a problem - just an idea of how to potentially improve the Cube's performance.

Describe the solution you'd like

Recently I checked Profile-Guided Optimization (PGO) improvements on multiple projects. The results are available here. According to the tests, PGO helps with achieving better performance in many software domains like databases, compilers, network applications, etc. I think trying to optimize Cube (its Rust part since Rust supports PGO) with PGO can be a good idea.

I can suggest the following action points:

• Perform PGO benchmarks on Cube. And if it shows improvements - add a note about possible improvements in Cube's performance with PGO.
• Providing an easier way (e.g. a build option) to build scripts with PGO can be helpful for the end-users and maintainers since they will be able to optimize Cube according to their own workloads.
• Optimize pre-built Cube binaries (like Docker containers) (if it's possible to prepare a good enough workload for PGO training)

Testing Post-Link Optimization techniques (like LLVM BOLT) would be interesting too (Clang and Rustc already use BOLT as an addition to PGO) but I recommend starting from the usual PGO.

Additional context
For the Rust projects, I recommend starting with cargo-pgo. More details about PGO support in Rust can be found in the official docs.

Here are some examples of how PGO optimization is integrated in other projects:

• Rustc: a CI script for the multi-stage build
• GCC:
  • Official docs, section "Building with profile feedback" (even AutoFDO build is supported)
  • A part in a "wonderful" configure script
• Clang: Docs
• Python:
  • CPython: README
  • Pyston: README
• Go: Bash script
• V8: Bazel flag
• ChakraCore: Scripts
• Chromium: Script
• Firefox: Docs
  • Thunderbird has PGO support too
• PHP - Makefile command and old Centminmod scripts
• MySQL: CMake script
• YugabyteDB: GitHub commit
• FoundationDB: Script
• Zstd: Makefile
• Foot: Scripts
• Windows Terminal: GitHub PR
• Pydantic-core: GitHub PR
• file.d: GitHub PR
• OceanBase: CMake flag
• NodeJS: Configure script

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.