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