Re: view reading information_schema is slow in PostgreSQL 12

2020-06-16 Thread regrog
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

view reading information_schema is slow in PostgreSQL 12

2020-06-12 Thread regrog
I'm facing performance issues migrating from postgres 10 to 12 (also from 11 to 12) even with a new DB. Th performance difference is huge 300ms in pg10 vs 3 minutes in pg12. I have a view that abstracts the data in the database: CREATE OR REPLACE VIEW public.my_constraints AS SELECT lower(tc.cons