blob: 633aed1dfcc9060c7fd4b722c64b647874375234 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
#
# 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
# Test/result database connection
TESTHOST=localhost
TESTUSER=postgres
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="select.sql"
SCALES="1 10 100 1000"
SETCLIENTS="1 2 4 8 16 32"
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
|
