QGIS freezes when deleting features from big PostGIS table

[qgib]

Author Name: Serge Dikiy (Serge Dikiy)
Original Redmine Issue: 6172
Affected QGIS version: master
Redmine category:vectors

---

Hi,

I have PostGIS table with 10e6 features. "Scale dependent" is set to display only 100-500 features. All work very fast..

But, if I want delete some features... QGIS freezes... because QGIS gets all 10e6 features from PostGIS.

See attachment.(test table have only 60 features)

BR.

---

• qgis_del_Feature.txt (Serge Dikiy)

[qgib]

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

---

Not a postgres provider problem. After features are deleted, the layer extents are recalculated by iterating all not deleted features.

---

• category_id was changed from Data Provider/PostGIS to Vectors

[qgib]

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

---

Fixed in changeset "2ab022184d377d1f50614b2887e18cef05eb38e1".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Serge Dikiy (Serge Dikiy)

---

Thank you, jef
Everything works great!