Content-Type: multipart/alternative;
 boundary="------------dz5W96baas2tcw0ObN7rHCbR"
Message-ID: <780e8797-b5a8-f02f-fbea-e01b625a34a7@gmail.com>
Date: Fri, 4 Mar 2022 21:42:53 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Content-Language: en-US
To: pgsql-general@lists.postgresql.org
References: <20220303150428.GA26036@depesz.com>
 <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>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: <3984384.1646431394@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/780e8797-b5a8-f02f-fbea-e01b625a34a7%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------dz5W96baas2tcw0ObN7rHCbR
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------dz5W96baas2tcw0ObN7rHCbR
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 3/4/22 17:03, Tom Lane wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:3984384.1646431394@sss.pgh.pa.us">
      <pre class="moz-quote-pre" wrap="">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?
</pre>
    </blockquote>
    <p>This is interesting and informative answer. How do I check
      whether JIT is used in the explain plan? Can you give me an
      example?</p>
    <p>TIA<br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>

--------------dz5W96baas2tcw0ObN7rHCbR--