[postgis-users] 3D topology nodes?

Sandro Santilli strk at keybit.net
Tue Jun 5 12:24:13 PDT 2012


On Tue, Jun 05, 2012 at 02:28:25PM -0400, John Morrison wrote:

> (3) I then walk the a tile's array, inserting topology nodes, then
> edges, then faces to make a triangulated height map (I guess you'd
> call it).  This seems to take about 10 minutes of wall clock time per
> tile (and I have 3700 or so).

Which functions do you use to add nodes, edges, faces ?
Could you instrument your code with clocks to further split those
10 minutes ? See also the log_min_duration_statement directive in
postgresql.conf to get timing of some queries on the backend side.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'




More information about the postgis-users mailing list