summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGreg Smith2010-01-11 06:33:08 +0000
committerGreg Smith2010-01-11 06:33:08 +0000
commit57964a7cbe181399bc650f1a3c1c036bb0cee73f (patch)
treeba138a6641118a43b8d44bd5179735f87fc21121
parent13ab355ead8b9a60de22eee3de0f1f3589fddacb (diff)
Finish 8.4 compatibility. Remove redundant vacuum.
-rw-r--r--README3
-rwxr-xr-xbenchwarmer9
2 files changed, 6 insertions, 6 deletions
diff --git a/README b/README
index 0b43616..36524f7 100644
--- a/README
+++ b/README
@@ -10,8 +10,9 @@ pgbench-tools Setup
* Initialize the results database by executing::
- psql -f init/resultdb.sql
+ psql -f init/resultdb.sql -d pgbench
+ Make sure to reference the correct database.
This will create a default test set entry with a blank description.
You may want to rename this.
diff --git a/benchwarmer b/benchwarmer
index cd0ab30..a4e7d98 100755
--- a/benchwarmer
+++ b/benchwarmer
@@ -49,7 +49,7 @@ echo Storing results using: $RESULTPSQL
# TODO If running a custom test, this won't return a useful value. Should
# include a config file setting for whether we're testing with the
# standard tables or not.
-SCALE=`$TESTPSQL -A -t -c "select count(*) from branches"`
+SCALE=`$TESTPSQL -A -t -c "select count(*) from ${TABLEPREFIX}branches"`
if [ -z "$SCALE" ]; then
echo ERROR: Attempt to determine database scale returned \"$SCALE\", aborting
exit
@@ -74,10 +74,9 @@ fi
# Cleanuip pgbench tables, unless we've been told to skip that
if [ "$SKIPINIT" -ne "1" ]; then
echo Cleaning up database $TESTDB
- $TESTPSQL -c 'truncate table history'
- $TESTPSQL -c 'vacuum'
- $TESTPSQL -c 'vacuum analyze'
- $TESTPSQL -c 'checkpoint'
+ $TESTPSQL -c "truncate table ${TABLEPREFIX}history"
+ $TESTPSQL -c "vacuum analyze"
+ $TESTPSQL -c "checkpoint"
# We want clean stats from the pg_stat_bgwriter, but those won't show up
# until after the checkpoint is done. Wait a bit for the stats to update
sleep 20