When using PostgreSQL/PostGIS triggers saving layer edits gets slower and slower every time when saving a layer edit. This issue occurs after a few up to a few dozen saved layer edits. Finally QGIS freezes completely.

I've tried the posted triggers in the folowing link:

How to use interacting PostgreSQL/PostGIS triggers in QGIS to create multiple labels on polygons?

Has anyone else made this observation? I've installed QGIS 2.12.

  • Have you checked to see if QGIS has any queries running in pg_stat_activity? – dbaston Jan 15 '16 at 0:35
  • That behaviour sounds a lot like a bad plugin. Are you sure it's related to the triggers and not something else? – ndawson Jan 15 '16 at 8:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.