Questions tagged [jit]

Just-In-Time (JIT) compilation is a way of executing computer code that involves compilation during execution of a program – at run time – rather than prior to execution. Used in some database systems to accelerate performance.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

Does PostgreSQL JIT compile index creation?

Does the LLVM-backed JIT compilation that shipped in PostgreSQL 11 JIT compile index creation (a CREATE INDEX query)?
6
votes
1answer
2k views

Handling performance problems with jit in postgres 12

tl;dr: What is the best way to handle performance decrease caused by jit? Background: Lately I have migrated from postgres 11 to 12 and noticed, that some queries / procedures run considerably ...
1
vote
2answers
939 views

Queries on large database kill connection to the server, works with LIMIT

I'm trying to run queries on a large-ish database without killing the connection to the server. I'm using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is ...
3
votes
1answer
418 views

How to tell if Postgres was built with the option to include LLVM technology for JIT?

Postgres 11 gained the ability to perform Just-in-Time Compilation (JIT) based on LLVM technology. The manual notes that this feature depends on Postgres having been built with the --with-llvm ...