[Qgis-user] qgis essen + postgis / long project init times

he same table is referenced multiple times. Its a waste of i/o and CPU. I am currently out of ideas to get this to acceptable times. Flo -- Florian Lohoff f...@zz.de We need to self-defend - GnuPG/PGP e

[Qgis-user] QGis checks uniqueness of primary key on startup

ignore the primary key? Or can i tell qgis that the key is unique, trust me? Currently i am fighting against QGis startup times 20 Minutes. Flo PS: QGis 2.0.1, Postgres 9.1, Postgis 2.0.3 -- Florian Lohoff f...@zz.de signature.asc Description

Re: [Qgis-user] QGis checks uniqueness of primary key on startup

with a foreign key. Flo -- Florian Lohoff f...@zz.de signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGis checks uniqueness of primary key on startup

at a scale of 1:8000 QGis does a full table scan on that table to check for uniqueness of the key. It does so twice by the way - once to check for uniqueness, once to do an st_extent on the geometry ... Flo -- Florian Lohoff f...@zz.de signature.asc

Re: [Qgis-user] QGis checks uniqueness of primary key on startup

at scale 1:8000. flo -- Florian Lohoff f...@zz.de signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user