[postgis-devel] topology : new index on node table
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...
More information about the postgis-devel