Horton

Re: information_schema performance in Postgres 12

Michael Lewis <mlewis@entrata.com>

View thread View on postgr.es
From: Michael Lewis <mlewis@entrata.com>
To: Eric Gillum <eric@hazel.co>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2020-02-26T16:40:42Z
Lists: pgsql-general 
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.

Commits

  1. Suppress unnecessary RelabelType nodes in more cases.