[postgis-devel] topology : new index on node table
remi.cura at gmail.com
Tue Jul 29 04:25:59 PDT 2014
send it too early :-(
I was going to say that this column is pretty important because it is most
direct way to know if a point is isolated or not (except looking in
edge_data start and end node to check if the point is there).
2014-07-29 13:23 GMT+02:00 Rémi Cura <remi.cura at gmail.com>:
> 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