From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de> |
Subject: | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |
Date: | 2022-03-04 22:03:14 |
Message-ID: | 3984384.1646431394@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-pkg-debian |
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Fri, Mar 04, 2022 at 02:09:52PM -0500, Tom Lane wrote:
>> 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.
Mmm ... it might have just been that the planner chose not to use
JIT when it thought there were fewer rows involved. Did you check
with EXPLAIN that these cut-down cases still used JIT?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2022-03-05 02:42:53 | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |
Previous Message | hubert depesz lubaczewski | 2022-03-04 20:45:10 | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2022-03-05 02:42:53 | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |
Previous Message | hubert depesz lubaczewski | 2022-03-04 20:45:10 | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |