Evaluate using Profile-Guided Optimization (PGO) for Supabase's Rust projects

[zamazan4ik]

Hi!

Recently I did many Profile-Guided Optimization (PGO) benchmarks on multiple projects (including many databases like PostgreSQL, ClickHouse, Redis, MongoDB; compilers, parsers, network proxies, etc.) - the results are available here. Since the performance improvement from enabling PGO is big enough, I think it's worth trying to apply PGO for Supabase projects like pg_replicate, pg_graphql, edge-runtime (possibly there are others).

I can suggest the following things to do:

• Evaluate PGO's results on projects on some benchmarks.
• If PGO helps to achieve better performance - add a note to the documentation about that. In this case, users and maintainers will be aware of another optimization opportunity with PGO.
• Provide PGO integration into the build scripts. It can help users and maintainers easily apply PGO for their workloads.
• Optimize prebuilt binaries with PGO if you prebuild them.

After PGO, I can suggest evaluating PLO with LLVM BOLT as an additional optimization step. However, I recommend starting with PGO.

For Rust projects, I have several useful links:

• The Rustc documentation about PGO: https://doc.rust-lang.org/rustc/profile-guided-optimization.html
• A useful wrapper around Cargo to optimize projects with PGO - cargo-pgo

Thank you.