When opening a qgis file with many layers (20 or so) it takes +5 minutes to load.All the layers come from a single PostGis database.
When looking into the server logs, i see that there are many requests like:
LOG: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1700LOG: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=34757 AND attnum=3LOG: SELECT description FROM pg_description WHERE objoid=34757 AND objsubid=3Since there are thousands (+3000) of these queries, i suppose the problem lies there...
Any idea?
Thanks
أكثر...
When looking into the server logs, i see that there are many requests like:
LOG: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1700LOG: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=34757 AND attnum=3LOG: SELECT description FROM pg_description WHERE objoid=34757 AND objsubid=3Since there are thousands (+3000) of these queries, i suppose the problem lies there...
Any idea?
Thanks
أكثر...