Postgres Pro
Downloads
Home   >   mailing lists

Re: information_schema performance in Postgres 12 - Mailing list pgsql-general

From Eric Gillum
Subject Re: information_schema performance in Postgres 12
Date
Msg-id CAMmjdmsQLj6VjQ=Dt49HGxV51iOPCAD7XP39m3VGOpXF+y9BwA@mail.gmail.com
Whole thread Raw
In response to Re: information_schema performance in Postgres 12  (Michael Lewis <mlewis@entrata.com>)
Responses Re: information_schema performance in Postgres 12  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Does not seem to improve if I turn off JIT. 

# show jit;
 on
# explain analyze SELECT tc.table_name, ...
 Planning Time: 8.806 ms
 Execution Time: 511.249 ms
# set jit=false;
# show jit;
 off
# explain analyze SELECT tc.table_name, ...
 Planning Time: 8.980 ms
 Execution Time: 506.016 ms



On Wed, Feb 26, 2020 at 8:41 AM Michael Lewis <mlewis@entrata.com> wrote:
Have you tried with JIT turned off in PG12? The long running node is ProjectSet type which is related to set returning functions. If that is getting evaluated differently in PG12, that may be issue.

pgsql-general by date:

Previous
From: Klaus Darilion
Date:
Subject: How to know if initial sync of logical subscription is finished
Next
From: Albrecht Dreß
Date:
Subject: Re: Error“cache lookup failed for function”