[postgis-tickets] r15273 - Add simple performance tester for TopoGeo_addLinestring

[Sandro Santilli]

Author: strk
Date: 2016-12-10 01:33:36 -0800 (Sat, 10 Dec 2016)
New Revision: 15273

Added:
   trunk/topology/test/perf/
   trunk/topology/test/perf/TopoGeo_addLinestring.sql
Log:
Add simple performance tester for TopoGeo_addLinestring

Added: trunk/topology/test/perf/TopoGeo_addLinestring.sql
===================================================================
--- trunk/topology/test/perf/TopoGeo_addLinestring.sql	                        (rev 0)
+++ trunk/topology/test/perf/TopoGeo_addLinestring.sql	2016-12-10 09:33:36 UTC (rev 15273)
@@ -0,0 +1,10 @@
+SELECT DropTopology('topoperf');
+SELECT CreateTopology('topoperf');
+\timing
+SELECT count(*) FROM (
+  SELECT TopoGeo_addLinestring('topoperf', g) FROM (
+    SELECT ST_ExteriorRing(ST_Buffer(ST_MakePoint(x, y), 10, 10)) g FROM
+      generate_series(-15,15,5) x,
+      generate_series(-15,15,5) y
+  ) foo
+) bar;