[postgis-users] TOPOLOGY St_remedgenewface strange behavior
christophe vergon
christophevergon-girtec at orange.fr
Tue Apr 12 11:18:16 PDT 2016
Thanks a lot
> Every update to the table leaves an orphaned record that's removed
> on vacuum. The topology functions make lots of updates, so you'd
> better enable autovacuum and/or automatically vacuum every N edge
> deletion.
Ok ! My work's DB contains one million of face so I'm working now on topology requests to improve automatic topological traitement and preserve relation with GeoTopoObject objects. Hoply I test it on a smaller test DB !!
>
> > I use the same way to remove edges wich have an area0 AND right_face<>0, I'd treated 100 000 Edges in 45 mm ...
> >
> > I use postgis 2.0
>
> Is that 2.0.0 or which exact version ?
> Some performance improvements were added in 2.0.2, for example
> (adding indexes on start_node and end_node fields of the edge_data
> table, do you have those ?)
Nice I've got them.
Thanks again
>
> Latest release in 2.0 branch was 2.0.7 from last year.
>
> --strk;
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160412/b8ce4913/attachment.html>
More information about the postgis-users
mailing list