From 90a5e5667091ef918cf0c853661648b966ecf28a Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Sat, 10 Dec 2016 09:33:36 +0000 Subject: [PATCH] Add simple performance tester for TopoGeo_addLinestring git-svn-id: http://svn.osgeo.org/postgis/trunk@15273 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/test/perf/TopoGeo_addLinestring.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 topology/test/perf/TopoGeo_addLinestring.sql diff --git a/topology/test/perf/TopoGeo_addLinestring.sql b/topology/test/perf/TopoGeo_addLinestring.sql new file mode 100644 index 000000000..f1749fd3b --- /dev/null +++ b/topology/test/perf/TopoGeo_addLinestring.sql @@ -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; -- 2.50.1