[Qgis-user] opening multitable postgis view is slow

[Lassche, M.R.]

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