TLDR Web Dev · MISCELLANEOUS

PLAYING WITH BOLT AND POSTGRES

vondra.me15 min read

Summary from the TLDR Web Dev newsletter

BOLT is a binary optimization tool from LLVM that improves PostgreSQL performance. It can significantly increase performance, sometimes by 30-40%, but the effectiveness depends greatly on the profile used to guide the optimization. While BOLT itself may not be directly implemented in PostgreSQL, the learnings from the experiment could help future code and build adjustments generate more efficient executables.