A developer shares their experience building a new JIT compiler for PostgreSQL, using the copy-and-patch methodology. They discuss the limitations of using LLVM as a JIT compiler and explain how copy-and-patch provides a faster and more efficient alternative. The developer also provides benchmarks comparing the performance of the JIT engine to the PostgreSQL interpreter.
Table of contents
In the beginning, there was no JIT, and then came the LLVM JIT compilerAnd in 2021, copy-and-patch was described…Bringing copy-and-patch to PostgreSQLCurrent stateTODO…Thanks1 Impression