[Qgis-user] Qgis slow in retrieving PGsql data.

[Brent Wood]

Nico,

Also check that the spatial tables have a spatial index, an integer unique key and run an ST_IsValid() check from Postgis on the geometries to ensure the data is clean before opening in QGIS.

Brent Wood



________________________________
 From: Luca Lanteri <mescal72 at gmail.com>
To: Nico Alberti <n8 at langhirano.it> 
Cc: qgis-user <qgis-user at lists.osgeo.org> 
Sent: Sunday, March 30, 2014 9:06 AM
Subject: Re: [Qgis-user] Qgis slow in retrieving PGsql data.
 


Which version of PostGIS are you using ?

You have to check to have at least select grants to the geometry_columns table (in postgis 1.5) or view (in postgis 2.0) in public schema.
If you can't access to this table qgis spends a lot of time in order to scan all geometries of all layer.


with PostGIS < 2.0 you also have to manually register you layer into the geometry_columns table
regards
Luca





2014-03-28 13:38 GMT+01:00 Nico Alberti <n8 at langhirano.it>:

Hi everybody. I am rather new to both technnologies (Qgis and PGsql data) so sorry if the question is lame. When I try to connect to a PGsql database, everything goes fine; layers are correctly listed and I can see their geometry type and primary keys. However the "add layer" [1] is disabled: on the lower left part of QGis there is a message saying that QGis is busy scanning the "the_geom" column, and this is taking a lot of time (there are several huge datasets in that db).
>
>After the scan is over, eventually I am not able to load most of the datasets. A message states they are invalid and cannot be loaded.
>
>I know I am not giving you a lot of hints. The errors are quite generic. However when I try to connect to another PGsql database (one that I can fully manage) everything goes fine. Could the dataset be corrupted in some strange way, could they lack something that forces QGis to scan the entire geometry data?
>
>Every suggestion would be greatly appreciated. Thank you in advance.
>
>[1] messages are in Italian, as you can guess. The actual English message is probably different.
>-- 
>Ciao
>Nico
>_______________________________________________
>Qgis-user mailing list
>Qgis-user at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user
>


_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140329/747c0e87/attachment.html>