Peter Eisentraut: PostgreSQL compile times
What’s the fastest compiler for PostgreSQL? Let’s take a look. OS Compiler time make -s macOS 13 gcc-13 3:59.29 gcc-12 3:42.19 gcc-11 3:33.35 clang-16 3:05.05 clang-15 2:19.71 clang-14 2:21.03 clang-13 2:20.72 Apple clang (14) 1:55.87 Ubuntu 22.04 gcc-12 (default) 2:57.87 gcc-11 2:24.20 gcc-10 2:18.28 clang-15 2:21.62 clang-14 2:24.23 clang-13 2:25.68 Compilers keep getting slower, it appears! Maybe don’t use the latest one right away! Also, gcc vs clang? Not sure, it depends. The above uses the default optimization level -O2. Let’s see if we can squeeze out more: Optimization Apple clang gcc-13 -O3 1:55.10 4:26.59 -O2 1:52.13 [...]
本文测试了不同编译器在不同优化级别和并行度下编译PostgreSQL的速度。结果显示,不同编译器和优化级别对速度影响较大,但并行度对速度提升有限。建议根据硬件和软件情况选择合适的编译器和优化级别。