Bug report #1174

QGIS slows down PostgreSQL

Added by Paolo Cavallini about 12 years ago. Updated about 11 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 about 12 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 about 12 years ago

can you please verify this with current trunk?

#3 Updated by Paolo Cavallini about 12 years ago

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

Tested, seems entirely solved

#4 Updated by Anonymous about 11 years ago

Milestone Version 1.0.0 deleted

Also available in: Atom PDF