Add PGO build types

[NatashaSerebryanaya]

Description

We need to add 2 PGO build types - for profile generation and profile use.

[zamazan4ik]

Is it still an actual issue? However, I could suggest additionally trying to use LLVM Bolt as an additional optimization step.

Links:

• ScyllaDB results with LTO + PGO + BOLT: build: introduce LTO, PGO and BOLT to the build scylladb/scylladb#10808
• Rust experience with LTO + PGO + BOLT: https://kobzol.github.io/rust/rustc/2022/10/27/speeding-rustc-without-changing-its-code.html
• Good chance to optimize build times of the project with PGO too: Compile times can be significantly reduced by optimizing the compiler scylladb/scylladb#10985

[NatashaSerebryanaya]

@zamazan4ik Thanks, this issue is done, will try Bolt when have time.