[Qgis-developer] Trouble with PostGis

walter.nordmann walter.nordmann at web.de
Tue Nov 4 11:10:16 PST 2014


Yea, did it the last 2 hours. but remember: I costs me tree days of work to
*see* the query :(

here we go:

runs for about *3-4 hours*

about *40 Seconds*

The cursor-query does not use the indexes for admin_level and boundary.
that's nearly like a sequential search (on 159 mio. datarecords).

But i think, that is a postgresql-problem. Any hints what i can do?

Regards
walter




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp5166669p5171214.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.


More information about the Qgis-developer mailing list