[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