--- title: "Look ma, I wrote a new JIT compiler for PostgreSQL – Pinaraf's website" url: https://daily.dev/posts/look-ma-i-wrote-a-new-jit-compiler-for-postgresql-pinaraf-s-website-y9mjsuv4t source_url: https://www.pinaraf.info/2024/03/look-ma-i-wrote-a-new-jit-compiler-for-postgresql/ type: article source: "Hacker News" published: 2024-03-18T12:44:25.490Z updated: 2026-03-15T05:16:57.679Z tags: ["cpython", "general-programming", "performance", "postgresql"] reading_time: 9 upvotes: 2 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Look ma, I wrote a new JIT compiler for PostgreSQL – Pinaraf's website **[Hacker News](https://daily.dev/sources/hn)** · 9 min read · 2 upvotes · 0 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#cpython](https://daily.dev/tags/cpython), [#general-programming](https://daily.dev/tags/general-programming), [#performance](https://daily.dev/tags/performance), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/look-ma-i-wrote-a-new-jit-compiler-for-postgresql-pinaraf-s-website-y9mjsuv4t)