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
