The author shares their experience playing with the BOLT tool from the LLVM project, which optimizes binaries and improved performance by up to 40%. They also explore the challenges of benchmarking due to binary layout differences, highlighting the complexity of proving performance regressions and discussing the potential of tools like Stabilizer. The author encounters difficulties with using BOLT, such as issues with outdated versions and missing libraries. Ultimately, after custom building LLVM tools, they see significant improvements in benchmarks for both OLTP and OLAP workloads, demonstrating the effectiveness of optimizing binary layouts.
https://vondra.me/posts/playing-with-bolt-and-postgres/