# # Basic setup options. If you are running as the postgres user and # are using PostgreSQL 8.4 or later, you normally don't need to # change any of these. # BASEDIR=`pwd` PGBENCHBIN=`which pgbench` # These values are for pgbench 8.4 and later TABLEPREFIX="pgbench_" TESTDIR="tests" # Use these values for pgbench 8.3 #TABLEPREFIX="" #TESTDIR="tests-8.3" # SKIPINIT should be set to 1 either when simulating a cold cache, or # if you are not using the pgbench tables for your test SKIPINIT=0 # Set TABBED to 1 to use Javascript for a multi-tabbed display format TABBED=0 # Test/result database connection TESTHOST=localhost TESTUSER=`whoami` TESTPORT=5432 TESTDB=pgbench RESULTHOST="$TESTHOST" RESULTUSER="$TESTUSER" RESULTPORT="$TESTPORT" RESULTDB=results # # Main test run customization # # Set this to a number only when using pgbench 9.0 or later. This will set # the number of worker threads up to this maximum for each client count MAX_WORKERS="" SCRIPT="insert.sql" SCALES="20" SETCLIENTS="1 2 4 8 16 32 50 150 250 350 450 700" SETTIMES=3 # RUNTIME is in seconds. If it is specified, then TOTTRANS is ignored. # Setting a time instead of a transaction account is only available # in 8.4 and later. RUNTIME=60 TOTTRANS="" # Use a transaction count instead for 8.3 or earlier #RUNTIME="" #TOTTRANS=100000