Bug report #13208

Poor attribute query and spatial selection performance on large PostGIS layers

Added by Bogdan Caradima about 9 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Attribute table
Affected QGIS version:2.8.2 Regression?:No
Operating System:Windows 8.1 Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:21269

Description

When opening attribute tables of larger data sets, QGIS opens a dialogue displaying the number of features loaded, takes a long time to load all the features, and consumes abnormal amounts of memory (~1.1GB) in the process (see attached screenshot). During this time, QGIS is otherwise unusable. The dataset size is 4.7 million features with 40 or so fields (2.1GB attribute table as a DBF). I have reproduced this problem with the same dataset as a shapefile, file geodatabase feature class, and PostGIS table. For PostGIS, I used PostgreSQL 9.4 x64 and PostGIS 2.1 on a local database stored on an SSD, with maintenance queries and spatial indices built.Performing attribute queries and spatial selections based on PostGIS geometries is also very slow.

PS; On an unrelated note, I've also noted very slow performance with the PostGIS raster driver when using raster2pgsql to import indexed and tiled rasters. I would be willing to file and document a second bug report on this issue but I think it has been previously reported.

Capture2.PNG (689 KB) Bogdan Caradima, 2015-08-11 12:04 PM


Related issues

Related to QGIS Application - Bug report #10619: Attribute table 'Show features visible on map' option doe... Closed 2014-06-18

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF