Date: Fri, 4 Mar 2022 21:45:10 +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: <20220304204510.GA21340@depesz.com>
Reply-To: depesz@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>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <3969790.1646420992@sss.pgh.pa.us>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20220304204510.GA21340%40depesz.com>
Precedence: bulk

On Fri, Mar 04, 2022 at 02:09:52PM -0500, Tom Lane wrote:
> arm64, eh?  I wonder if that's buggier than the Intel code paths.
> 
> I tried and failed to reproduce this on Fedora 35 on aarch64,
> but that has what I think is a newer LLVM version:

I have suspicion that it also kinda depends on number of rows in there.

When I deleted some schemas, which included some functions, the problem
disappeared.

I wasn't able to pinpoint specific thing, though, and when I called the
pg_proc + pg_roles query for each separate row - it worked flawlessly.

Best regards,

depesz