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

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


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

Cheers,
Rémi-C



2014-07-29 13:23 GMT+02:00 Rémi Cura <remi.cura at gmail.com>:

> 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/b82b1e65/attachment.html>


More information about the postgis-devel mailing list