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;
>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users