Bug report #1174

QGIS slows down PostgreSQL

Added by Paolo Cavallini almost 16 years ago. Updated over 14 years ago.

Status:Closed
Priority:Low
Assignee:Jürgen Fischer
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:Debian Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:11234

Description

When qgis (0.10 on deb) queries the db (to load geometries) often postgres takes up a very large amount of CPU, for many minutes. I once had even to kill postgres (!!). Does this happens to
others? We never noticed it before. Tested on several db.

History

#1 Updated by Paolo Cavallini almost 16 years ago

A possible explanation here:
http://www.rigacci.org/wiki/doku.php/tecnica/gps_cartografia_gis/postgis#quinto_esempio
(in IT, but at least some of you can understand).

#2 Updated by Jürgen Fischer over 15 years ago

can you please verify this with current trunk?

#3 Updated by Paolo Cavallini over 15 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

Tested, seems entirely solved

#4 Updated by Anonymous over 14 years ago

Milestone Version 1.0.0 deleted

Also available in: Atom PDF