From 059e1c65b3650c7f0883dcfec9765da42b905cff Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Tue, 28 Jun 2005 22:01:27 +0000
Subject: [PATCH] Added index concurrency tester

git-svn-id: http://svn.osgeo.org/postgis/trunk@1794 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/test_index_concurrency | 41 ++++++++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100755 regress/test_index_concurrency

diff --git a/regress/test_index_concurrency b/regress/test_index_concurrency
new file mode 100755
index 000000000..612ed6352
--- /dev/null
+++ b/regress/test_index_concurrency
@@ -0,0 +1,41 @@
+#!/bin/sh
+
+if [ -z "$TMPDIR" ]; then
+	TMPDIR=/tmp
+fi
+
+OUTFILE="${TMPDIR}/regress_index_out_$$"
+
+echo "Running GiST concurrency Regression."
+
+DB=postgis_reg
+export PGDATABASE=$DB
+
+if [ "$1" = "prepare" ]; then
+	echo ""
+	echo "Index Creation will take some time..."
+	echo ""
+
+	createdb > /dev/null
+	createlang plpgsql > /dev/null
+	psql -f ../lwpostgis.sql > /dev/null 2>&1
+
+	psql -f regress_lots_of_points.sql 
+	psql -c "CREATE INDEX quick_gist on test using gist (the_geom)" 
+else
+if [ "$1" = "run" ]; then
+	# Concurrent clients:
+	psql -c "update test set num=-num WHERE the_geom && 'BOX3D(125 125,135 135)'::box3d"  &
+	psql -c "update test set num=-num WHERE the_geom && 'BOX3D(125 125,135 135)'::box3d"  &
+	psql -c "update test set num=-num WHERE the_geom && 'BOX3D(125 125,135 135)'::box3d"  &
+	 
+	wait
+else
+if [ "$1" = "drop" ]; then
+	dropdb $DB > /dev/null
+else
+	echo "Usage: $0 [prepare|run|drop]"
+fi
+fi
+fi
+
-- 
2.50.1