Postgres Pro
Downloads
Home   >   mailing lists

Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal - Mailing list pgsql-general

From Mladen Gogala
Subject Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Date
Msg-id 780e8797-b5a8-f02f-fbea-e01b625a34a7@gmail.com
Whole thread Raw
In response to Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Next
From: Tom Lane
Date:
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal