[Qgis-user] opening multitable postgis view is slow

[Fred Lehodey]

Hi,
would be nice to have an option like "try to use Estimated extent".

http://postgis.net/docs/ST_Estimated_Extent.html


Fred





On Wed, Apr 17, 2013 at 9:26 AM, Lassche, M.R. <m.r.lassche at vu.nl> wrote:

> Hi all,
>
> When loading multi table views in QGis it always starts with determining
> the extent of the result set.
> With pg_stat_activity you can see the following query running for a long
> time: SELECT st_extent("geom") FROM "bag"."vw_bag_pand_functie"
>
> Does anyone has ideas of how to speed up the loading this dataset in QGis.
> The view is as efficient as can be, it will normally returns something like
> 9 million rows for the whole of the Netherlands, but normally I zoom in to
> a region of interest and then there is no need of first establishing the
> extent of the whole data set.
>
> All suggestions are welcome
> Ronnie
> _______________________________________________
> 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/20130417/c89b60da/attachment.html>