[QGIS-trac] [Quantum GIS] #1855: Postgis View Layers with OID as primary key are loading very slow

Quantum GIS qgis at qgis.org
Mon Aug 3 09:33:55 EDT 2009


#1855: Postgis View Layers with OID as primary key are loading very slow
--------------------------------+-------------------------------------------
   Reporter:  hdus              |              Owner:  nobody       
       Type:  bug               |             Status:  new          
   Priority:  minor: annoyance  |          Milestone:  Version 1.2.0
  Component:  Data Provider     |            Version:  HEAD         
   Keywords:                    |   Platform_version:               
   Platform:  All               |           Must_fix:  Yes          
Status_info:  0                 |  
--------------------------------+-------------------------------------------
 I want to load a postgis view layer defined in a way that the OID
 represents the primary key of the view query result. No real primary key
 is defined in the source tables. When I query this view from psql it gives
 me the query result very fast. When I load this layer into QGIS it needs a
 very long time, more than 1 minute, to load this layer.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1855>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list