Re: [Qgis-user] slow to add postgis layer

2018-10-26 Thread Jürgen E . Fischer
Hi Andrew, On Fri, 26. Oct 2018 at 09:16:53 -0700, andrew terry wrote: > Is there any other indexing etc i should have in place to avoid QGIS doing > this? Did you enable the "use estimated metadata option" in the postgresql connection? Jürgen -- Jürgen E. Fischer norBIT GmbH

[Qgis-user] slow to add postgis layer

2018-10-26 Thread 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