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

Rémi Cura remi.cura at gmail.com
Tue Jul 29 04:23:31 PDT 2014

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).

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

More information about the postgis-devel mailing list