[postgis-users] spatial index for topology?

[Sandro Santilli]

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;