Date: Thu, 4 Nov 2021 20:56:32 +0000 (UTC)
From: ANASTACIO Tiago <tiago_anastacio@yahoo.fr>
To: "andres@anarazel.de" <andres@anarazel.de>,
	"pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
Message-ID: <190426807.1290718.1636059392618@mail.yahoo.com>
Subject: JIT llvm11 package
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1290717_2112725514.1636059392616"
References: <190426807.1290718.1636059392618.ref@mail.yahoo.com>
Content-Length: 3144
Archived-At: 
 <https://www.postgresql.org/message-id/190426807.1290718.1636059392618%40mail.yahoo.com>
Precedence: bulk

------=_Part_1290717_2112725514.1636059392616
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi guys,

PostgreSQL 13.4 for SUSE linux=C2=A0 (should be same behavior on red hat)__=
_______________________________________________________
=C2=A0We installed the llvmJIT community RPM =3D> postgresql13-llvmjit-13.4=
-1PGDG.sles15.x86_64.rpm=C2=A0 =C2=A0

=3D> It requires libLLVM11 : https://opensuse.pkgs.org/15.3/opensuse-oss-aa=
rch64/libLLVM11-11.0.1-1.26.x86_64.rpm.html
=3D> Also requires llvm11 : https://opensuse.pkgs.org/15.3/opensuse-oss-aar=
ch64/llvm11-11.0.1-1.26.x86_64.rpm.html
=C2=A0=C2=A0For llvm11=C2=A0 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=
=C2=A0=C2=A0

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

Thank you very much

Best regards


------=_Part_1290717_2112725514.1636059392616
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div dir=
=3D"ltr" data-setdir=3D"false"><div><div>Hi guys,</div><div><br></div><div>=
<br></div><div>PostgreSQL 13.4 for SUSE linux&nbsp; (should be same behavio=
r on red hat)</div><div>___________________________________________________=
______</div><div><br></div><div>&nbsp;</div><div>We installed the llvmJIT c=
ommunity RPM =3D&gt; postgresql13-llvmjit-13.4-1PGDG.sles15.x86_64.rpm&nbsp=
; &nbsp;</div><div><br></div><div><br></div><div>=3D&gt; It requires libLLV=
M11 : https://opensuse.pkgs.org/15.3/opensuse-oss-aarch64/libLLVM11-11.0.1-=
1.26.x86_64.rpm.html</div><div><br></div><div>=3D&gt; Also requires llvm11 =
: https://opensuse.pkgs.org/15.3/opensuse-oss-aarch64/llvm11-11.0.1-1.26.x8=
6_64.rpm.html</div><div><br></div><div>&nbsp;&nbsp;</div><div>For llvm11&nb=
sp; we faced a security issue for installation in production because this l=
ib (llvm11) seems to be a kind of compiler.</div><div><br></div><div>So we =
installed *only* libLLVM11 (not llvm11) and tried the example test in JIT d=
ocumentation : https://www.postgresql.org/docs/11/jit-decision.html&nbsp;&n=
bsp;<br></div><div><br></div><div>it works...</div><div><br></div><div>&nbs=
p;=3D&gt; Could you please confirm if this library is really needed: 'llvm1=
1'&nbsp; or we can&nbsp; live only with 'libLLVM11' library installed and u=
sing PostgreSQL JIT feature&nbsp;</div><div><br></div><div>&nbsp;*without* =
any penalty on performances ?</div><div><br></div><div><br></div><div>Thank=
 you very much</div><div><br></div><div><br></div><div>Best regards</div><d=
iv><br></div></div><br></div></div></body></html>
------=_Part_1290717_2112725514.1636059392616--