On Sun, Mar 06, 2022 at 11:10:00AM -0500, Tom Lane wrote: > > I tore these boxes down, so can't check immediately, but I think > > I remember that you're right - single-row queries didn't use JIT. Got focal box up. Loaded schema for Pg. Initially select didn't break anything, but when I tuned down jit_above_cost so that it will kick in - got fails immediately. > FWIW, I went to the trouble of installing Ubuntu Focal on my > raspberry pi to see if I could duplicate this, and I couldn't. > However, what you get from a fresh install now is > $ dpkg -l | grep libllvm > ii libllvm10:arm64 1:10.0.0-4ubuntu1 arm64 Modular compiler and toolchain technologies, runtime library > not 9.0.1. I also found that Fedora 31/aarch64 is still downloadable, and > that does contain LLVM 9 ... and I could not reproduce it there either. Soo... plot thickens. Looks that pg 12 supplied by pgdg required libllvm9: =$ apt-cache show postgresql-12 | grep -E '^(Package|Version|Depends):' Package: postgresql-12 Version: 12.9-2.pgdg20.04+1 Depends: ..., libllvm9 (>= 1:9~svn298832-1~), ... Package: postgresql-12 Version: 12.9-0ubuntu0.20.04.1 Depends: ..., libllvm10 (>= 1:9~svn298832-1~), ... Package: postgresql-12 Version: 12.2-4 Depends: ..., libllvm10 (>= 1:9~svn298832-1~), ... Newer pg12 (12.10) from pgdg also depends on llvm9. Perhaps changing the deb to use/depend-on llvm10 would solve the problem, for now I'm not sure how to do it. Reached to Christoph about it. Best regards, depesz
