From: Tom Lane <tgl@sss.pgh.pa.us>
To: depesz@depesz.com
cc: PostgreSQL General <pgsql-general@lists.postgresql.org>,
        Andres Freund <andres@anarazel.de>
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
In-reply-to: <20220307151128.GA22074@depesz.com>
References: <20220303150428.GA26036@depesz.com>
 <20220303151156.GB26036@depesz.com> <20220303163921.GA10776@depesz.com>
 <20220303164401.GA13056@depesz.com> <3969790.1646420992@sss.pgh.pa.us>
 <20220304204510.GA21340@depesz.com> <3984384.1646431394@sss.pgh.pa.us>
 <20220306140402.GA6360@depesz.com> <2045.1646583000@sss.pgh.pa.us>
 <20220307151128.GA22074@depesz.com>
Comments: In-reply-to hubert depesz lubaczewski <depesz@depesz.com>
	message dated "Mon, 07 Mar 2022 16:11:28 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <202418.1646673746.1@sss.pgh.pa.us>
Date: Mon, 07 Mar 2022 12:22:26 -0500
Message-ID: <202419.1646673746@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/202419.1646673746%40sss.pgh.pa.us>
Precedence: bulk

hubert depesz lubaczewski <depesz@depesz.com> writes:
> 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.

Hmph.  I tried two more builds:

* downgraded llvm to llvm-9, compiled PG 12 from source

* installed postgresql-12.10-1.pgdg20.04+1 from pgdg repo

Neither of those configurations fail for me, so either
it's been fixed since 12.9, or (more likely) there is
something to your test case beyond what you've mentioned.

(I guess a long-shot possibility is that my raspberry pi 3B+
is sufficiently different hardware from your box as to not
see the problem.  Doubt that though.)

Can you create a self-contained test case?

			regards, tom lane