database/benchmark.sh in message-db-2.1.6 vs database/benchmark.sh in message-db-3.0.0
- old
+ new
@@ -33,30 +33,34 @@
database=$DATABASE_NAME
fi
echo "Database name is: $database"
echo
+function run_psql {
+ psql $database -v ON_ERROR_STOP=1 "$@"
+}
+
echo "Installing benchmark scripts"
echo
-psql $database -q -f $base/benchmark_write.sql
-psql $database -q -f $base/benchmark_get.sql
+run_psql -q -f $base/benchmark_write.sql
+run_psql -q -f $base/benchmark_get.sql
echo
echo "Benchmarking write"
echo "- - -"
echo
-psql $database -U message_store -c "EXPLAIN ANALYZE SELECT benchmark_write('$stream_name'::varchar, $cycles::int);"
+run_psql -U message_store -c "EXPLAIN ANALYZE SELECT benchmark_write('$stream_name'::varchar, $cycles::int);"
echo
echo
echo "Benchmarking get"
echo "- - -"
echo
-psql $database -U message_store -c "EXPLAIN ANALYZE SELECT benchmark_get('$stream_name'::varchar, $cycles::int);"
+run_psql -U message_store -c "EXPLAIN ANALYZE SELECT benchmark_get('$stream_name'::varchar, $cycles::int);"
echo "= = ="
echo "Done"
echo