Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Date: 2022-03-05 02:42:53
Message-ID: 780e8797-b5a8-f02f-fbea-e01b625a34a7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-pkg-debian

On 3/4/22 17:03, Tom Lane wrote:
> 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?

This is interesting and informative answer. How do I check whether JIT
is used in the explain plan? Can you give me an example?

TIA

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-03-05 02:48:33 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Previous Message Tom Lane 2022-03-04 22:03:14 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Tom Lane 2022-03-05 02:48:33 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Previous Message Tom Lane 2022-03-04 22:03:14 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal