diff options
author | Greg Smith | 2010-01-11 06:33:08 +0000 |
---|---|---|
committer | Greg Smith | 2010-01-11 06:33:08 +0000 |
commit | 57964a7cbe181399bc650f1a3c1c036bb0cee73f (patch) | |
tree | ba138a6641118a43b8d44bd5179735f87fc21121 | |
parent | 13ab355ead8b9a60de22eee3de0f1f3589fddacb (diff) |
Finish 8.4 compatibility. Remove redundant vacuum.
-rw-r--r-- | README | 3 | ||||
-rwxr-xr-x | benchwarmer | 9 |
2 files changed, 6 insertions, 6 deletions
@@ -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 |