[postgis-users] postgis topology performance

[Rémi Cura]

Surely !

I have to outline that grass export to postgis topology is still in beta
mode.
Also, I have a feeling the grass export to postgis topology uses the
postgis topology functions, which kind of defeat the purpose (should bulk
insert into tables).


I sent a separate message, but GEOS is also promising :
5 seconds to load everything, build topology, compute face, output faces,
impressive!

I shall have CGAL benchmark soon.

Cheers,

Rémi-C


2014-03-28 16:04 GMT+01:00 Sandro Santilli <strk at keybit.net>:

> On Tue, Mar 25, 2014 at 03:13:13PM +0100, Rémi Cura wrote:
> > Back after some other testing .
> >
> > (_from memory, suppressing checks in addpoints was about 2 sec instead
> of 3
> > sec.
> > _About 21k unique points.)
> >
> >
> > Here is a little comparison :
> > (32k polylines,21k unique points,  already 'topological'( no need to cut
> > the lines) ,with a lot of attributes)
> >
> > Postgis Topology
> > Postgis Topology (addtopogeom) : 700+ sec for 10k lines, (??about 1600
> sec
> > for 32k lines??)
> > Postgis Topology (addlinestring) : 240+ sec for 10k lines,  (??about 780
> > sec for 32k lines??)
> > Postgis Topology (addnode, addedge) : 80sec for 10 k lines (??about
> 260sec
> > for 32k lines??)
> >
> > Grass Gis 7 :
> > Importing everything : 10 sec
> > Importing only geom (no attributes) : 5 sec
> >
> > Importing everything then Exporting all topologies to postgis topology :
> > 150 sec
> > Declare postgis topo as external source and fill it with shapefile : 145
> sec
>
> Nice! GRASS seems to be the way to go here.
> It's interesting to see how a 10-seconds process becomes a 150-seconds
> one to ensure output is modeled after PostGIS/ISO model. There's maybe
> space for optimization there.
>
> --strk;
>
>  ()  ASCII ribbon campaign  --  Keep it simple !
>  /\  http://strk.keybit.net/rants/ascii_mails.txt
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140328/0954eb34/attachment.html>