JIT llvm11 package

From: ANASTACIO Tiago <tiago_anastacio(at)yahoo(dot)fr>
To: "andres(at)anarazel(dot)de" <andres(at)anarazel(dot)de>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: JIT llvm11 package
Date: 2021-11-04 20:56:32
Message-ID: 190426807.1290718.1636059392618@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi guys,

PostgreSQL 13.4 for SUSE linux  (should be same behavior on red hat)_________________________________________________________
 We installed the llvmJIT community RPM => postgresql13-llvmjit-13.4-1PGDG.sles15.x86_64.rpm   

=> It requires libLLVM11 : https://opensuse.pkgs.org/15.3/opensuse-oss-aarch64/libLLVM11-11.0.1-1.26.x86_64.rpm.html
=> Also requires llvm11 : https://opensuse.pkgs.org/15.3/opensuse-oss-aarch64/llvm11-11.0.1-1.26.x86_64.rpm.html
  For llvm11  we faced a security issue for installation in production because this lib (llvm11) seems to be a kind of compiler.
So we installed *only* libLLVM11 (not llvm11) and tried the example test in JIT documentation : https://www.postgresql.org/docs/11/jit-decision.html  

it works...
 => Could you please confirm if this library is really needed: 'llvm11'  or we can  live only with 'libLLVM11' library installed and using PostgreSQL JIT feature 
 *without* any penalty on performances ?

Thank you very much

Best regards

Browse pgsql-performance by date

  From Date Subject
Next Message arjun shetty 2021-11-05 12:07:40 Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Previous Message Imre Samu 2021-11-02 19:29:23 Re: PostgreSQLv14 TPC-H performance GCC vs Clang