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, 2016 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, 2016 at 8:01


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.