When adding PostGIS table, QGIS hangs because of expensive queries on views

[qgib]

Author Name: Aren Cambre (Aren Cambre)
Original Redmine Issue: 5052
Affected QGIS version: master
Redmine category:gui

---

If you click Add a PostGIS Layer and connect to a database with large views, QGIS will hang for a long time, even though the Add PostGIS Table(s) dialog still appears responsive, because QGIS is doing expensive queries on the database.

I don't think expensive queries should be run on views by default. The default behavior should require some kind of consent, either a global setting to QGIS or me selecting the view in the dialog, before expensive queries are run.

I have views with several hundreds of thousands of rows.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

enable "Use estimated metadata" in your postgresql connection.

---

• resolution was changed from to worksforme
• status_id was changed from Open to Closed