Date: Mon, 7 Mar 2022 20:35:40 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Tom Lane <tgl@sss.pgh.pa.us>
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
Message-ID: <20220307193540.GA30091@depesz.com>
Reply-To: depesz@depesz.com
References: <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>
 <202419.1646673746@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <202419.1646673746@sss.pgh.pa.us>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20220307193540.GA30091%40depesz.com>
Precedence: bulk

On Mon, Mar 07, 2022 at 12:22:26PM -0500, Tom Lane wrote:
> 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.

Upgraded to 12.10 from pgdg, same problem.

> (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.)

My "hardware" is AWS EC2 graviton instance (c6g.2xlarge).

> Can you create a self-contained test case?

I tried, but it seems that number of functions/users is a factor, and
I wasn't able to make simple test that would replicate the issue.

I guess I will just disable JIT on arm for now, and be done with it.

Best regards,

depesz