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

[Nico Alberti]

Thank you Brent and Luca. Today I could check that PostGis db again, and I
discovered that actually many layers lack spatial indexes or even unique
keys. Should have checked QGis logs more thoroughly :-) as the issue is
clearly shown there. As a matter of fact I did not even know QGis has a
log...

And for the original question I found that i can get rid of the "busy"
message box if I check the "do not resolve urestricted geometry types" in
the postgis connection parameters dialog (or something like that. As I said
in the OP I am using the Italian interface.

Thank you again.

Ciao
Nico



2014-03-29 23:38 GMT+01:00 Brent Wood <pcreso at pcreso.com>:

> 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/20140402/ba872c3e/attachment.html>