Bug report #13208
Poor attribute query and spatial selection performance on large PostGIS layers
|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|
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.
#2 Updated by Giovanni Manghi about 1 year ago
- Resolution set to end of life
- Status changed from Open to Closed
End of life notice: QGIS 2.18 LTR