config

#
# 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`
GNUPLOT=`which gnuplot`

# These values are for pgbench 9.6 - 13
TESTDIR="tests"

# Use this value for pgbench 8.4 - 9.5.  There is also a directory for 8.3.
# TESTDIR="tests/tests-9.5"

# 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

# Set OSDATA to 1 to collect OS data using vmstat and iostat
OSDATA=1

# Set SOCKETS to 1 to eliminate "-h host" from test connection string
SOCKETS=0

# Test/result database connection
#
# Using a URI for the DB fields will overwrite the standard (host,port,user) trio
# *only* if the URI specifies that section

TESTHOST=localhost
TESTUSER=`whoami`
TESTPORT=5432
TESTDB=pgbench

RESULTHOST="$TESTHOST"
RESULTUSER="$TESTUSER"
RESULTPORT="$TESTPORT"
RESULTDB=results

# What server name to use when saving the results.  It's just a label,
SERVERNAME=`hostname`

# Central server to upload results to
ARCHIVE="gsmith@pony"

# Integration for Crunchy Bridge metrics system
BRIDGE_CLUSTER_ID=""
BRIDGE_BEARER=""

#
# Main test run customization.  Test scripts add a .sql extension for you.
#

# New init style saves the database creation as a test itself,
# defaulting to the server-side option.  During that build,
# disabling the server side option gives default COPY style load.
NEWINIT=1
SERVERSIDE=1

# 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="auto"
# Blank setting, typically used with earlier pgbench versions
#MAX_WORKERS=""

SCRIPT="select"
SCALES="1 10 100 1000"
SETCLIENTS="1 2 4 8 16 32"
SETTIMES=3

# FILLFACTOR option
# uses fillfactor option from pgbench
# default is 100
FILLFACTOR="100"

# 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

# Starting in the 9.4 pgbench, you can limit the maximum rate.
# This takes a list like scale and clients
SETRATES=""

# Alternately and preferred if you enable both, list some maximum
# rates per client to test and the total rate will scale based on it.
CLIENTRATES=""

# Set to 1 to compute a lot of latency buckets at 1% intervals
LARGEBUCKETS=0

# Set to 1 to use prepared statements (pgbench -M)
PREPARED=0

# Set to 1 to trim 10% off the start and end of the test
TRIM=0

# Set over 0 to target more pages of data per transaction using a range sweep
MULTI=0

#
# Disk inclusion prefix list.  Only active for Linux system monitoring.  Mac systems
# ignore this in the code, setting it there is only useful for documenting the database disk.
#
DISKLIST="sda"