[postgis-devel] topology : new index on node table

[Rémi Cura]

Hey,
it seems there is no index on
node.containing_face in a classical topology schema.

Is there a special reason to do so ?
On my sample data (about 25k node, 30 k edge), using such an index (`CREATE
INDEX ON bdtopo_topological.node (containing_face)`) make looking for a
containing_face going from 15ms to 0.5 ms (30 times faster).

Cheers,
Rémi-C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140729/8ef6fa0a/attachment.html>