[postgis-users] spatial index for topology?
Sandro Santilli
strk at keybit.net
Mon Oct 28 05:22:52 PDT 2013
On Mon, Oct 28, 2013 at 09:48:25AM +0100, RĂ©mi Cura wrote:
> Hey,
> in QGIS you will have slow visualization essentially on faces.
>
> If your topogeom are based on node or edge it is faster.
Any topogeometry layer is slow with QGIS, as it cannot use
an index in any case.
> If not, I use materialized view (requiere postgres 9.3), as a "buffer" for
> qgis. The problem is QGIS 2.0 doesn't support yet materialized view, so you
> have to create a proxy view onto your materialized view for qgis!
> It is a bit of useless code but it is a great comfort gain.
Interesting tip. Why doesn't QGIS support materialized views ?
Sounds like a possibly very easy thing to add, did you file a ticket
in there ?
> Also, you can use QGis visualisation settings to make the element appears
> dynamically, again this is better than just waiting with blank screen
Ohh, lots of good info here. How do you do that ?
Hey, what about writing some of these tips into the postgis wiki ?
"Working with topology in qgis"
--strk;
More information about the postgis-users
mailing list