[Qgis-user] slow to add postgis layer

[andrew terry]

Hi,

I'm finding big postgis tables slow to add to QGIS:
 - this is when zoomed in to a small area with a spatial index on the table
 - the tables are exclusively linestring (i know combinations result in
querying of the geometry types)

>From the database side i can see that it's receiving a SELECT count(*) FROM
schemaname.tablename

Is there any other indexing etc i should have in place to avoid QGIS doing
this?

Thanks

Andy



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html