Date: Tue, 16 Jun 2020 02:23:14 -0700 (MST)
From: regrog <andrea.vencato@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1592299394670-0.post@n3.nabble.com>
In-Reply-To: <1591975278775-0.post@n3.nabble.com>
References: <1591975278775-0.post@n3.nabble.com>
Subject: Re: view reading information_schema is slow in PostgreSQL 12
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk

I tested both postgres 12.3 and 13 beta 1 and the results are the same.

I could read the pg_ tables instead of the views in the information_schema
but that's the SQL standard schema so I'd prefer to stick to that.

I reported this issue because the performance gap is huge and that could be
useful to bring in some improvements.

The DDL is still evolving so a materialized table/view is not an option at
the moment.

I'll try to remove the <> 'CHECK' clause, I'm quite sure we needed that for
some reason but I didn't follow that change.

Thanks


--
Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html