PostgreSQL pgbench 1.5.0

pts/pgbench-1.5.0 - 09 June 2015 - Major update/overhaul of pgbench PostgreSQL benchmark.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://ftp.postgresql.org/pub/source/v9.4.3/postgresql-9.4.3.tar.bz2</URL>
      <MD5>05217e0921b51fb886e9e50875776bf1</MD5>
      <SHA256>734acfd2ac352dd0cd353d226f3199c2e1a2730200998aea5b38cf685136d755</SHA256>
      <FileSize>17618524</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh

version=9.4.3
tar -xjf postgresql-${version}.tar.bz2 

rm -rf $HOME/pg_
mkdir -p $HOME/pg_/data/postgresql/extension/
touch $HOME/pg_/data/postgresql/extension/plpgsql.control

cd postgresql-${version}
./configure --prefix=$HOME/pg_ --without-readline --without-zlib
make -j $NUM_CPU_JOBS
make -C contrib/pgbench all
echo $? > ~/install-exit-status
make install
make -C contrib/pgbench install
cd ..
rm -rf postgresql-${version}/
rm -rf pg_/doc/

# initialize database with encoding and locale
$HOME/pg_/bin/initdb -D $HOME/pg_/data/db --encoding=SQL_ASCII --locale=C

echo "#!/bin/sh
PGDATA=\$HOME/pg_/data/db/
PGPORT=7777
export PGDATA
export PGPORT
# start server
pg_/bin/pg_ctl start -o '-c checkpoint_segments=8 -c autovacuum=false'
# wait for server to start
sleep 10

# create test db
pg_/bin/createdb pgbench

# set up tables
case \$1 in
	\"BUFFER_TEST\")
		SCALING_FACTOR=\`echo \"\$SYS_MEMORY * 0.003\" | bc\`
	;;
	\"MOSTLY_CACHE\")
		SCALING_FACTOR=\`echo \"\$SYS_MEMORY * 0.03\" | bc\`
	;;
	\"ON_DISK\")
		SCALING_FACTOR=\`echo \"\$SYS_MEMORY * 0.3\" | bc\`
	;;
esac

pg_/bin/pgbench -i -s \$SCALING_FACTOR pgbench

case \$2 in
	\"SINGLE_THREAD\")
		PGBENCH_ARGS=\"-c 1\"
	;;
	\"NORMAL_LOAD\")
		PGBENCH_ARGS=\"-j \$NUM_CPU_CORES -c \$((\$NUM_CPU_CORES*4))\"
	;;
	\"HEAVY_CONTENTION\")
		PGBENCH_ARGS=\"-j \$((\$NUM_CPU_CORES*2)) -c \$((\$NUM_CPU_CORES*32))\"
	;;
esac

case \$3 in
	\"READ_WRITE\")
		PGBENCH_MORE_ARGS=\"\"
	;;
	\"READ_ONLY\")
		PGBENCH_MORE_ARGS=\"-S\"
	;;
esac

# run the test 
pg_/bin/pgbench \$PGBENCH_ARGS \$PGBENCH_MORE_ARGS -T 60 pgbench >\$LOG_FILE 2>&1
# drop test db
pg_/bin/dropdb pgbench
# stop server
pg_/bin/pg_ctl stop" > pgbench
chmod +x pgbench

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>tps = #_RESULT_# (excluding connections establishing) TPS</OutputTemplate>
    <LineHint>excluding connections establishing</LineHint>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v5.8.0 (Belev)-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>PostgreSQL pgbench</Title>
    <AppVersion>9.4.3</AppVersion>
    <Description>This is a simple benchmark of PostgreSQL using pgbench.</Description>
    <ResultScale>TPS</ResultScale>
    <Proportion>HIB</Proportion>
    <Executable>pgbench</Executable>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.5.0</Version>
    <SupportedPlatforms>Linux, MacOSX, Solaris</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities</ExternalDependencies>
    <EnvironmentSize>990</EnvironmentSize>
    <ProjectURL>http://www.postgresql.org/</ProjectURL>
    <InternalTags>SMP</InternalTags>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Scaling</DisplayName>
      <Identifier>scaling-factor</Identifier>
      <DefaultEntry>0</DefaultEntry>
      <Menu>
        <Entry>
          <Name>Buffer Test</Name>
          <Value>BUFFER_TEST</Value>
        </Entry>
        <Entry>
          <Name>Mostly RAM</Name>
          <Value>MOSTLY_CACHE</Value>
        </Entry>
        <Entry>
          <Name>On-Disk</Name>
          <Value>ON_DISK</Value>
        </Entry>
      </Menu>
    </Option>
    <Option>
      <DisplayName>Test</DisplayName>
      <Identifier>run-test</Identifier>
      <DefaultEntry>0</DefaultEntry>
      <Menu>
        <Entry>
          <Name>Single Thread</Name>
          <Value>SINGLE_THREAD</Value>
        </Entry>
        <Entry>
          <Name>Normal Load</Name>
          <Value>NORMAL_LOAD</Value>
        </Entry>
        <Entry>
          <Name>Heavy Contention</Name>
          <Value>HEAVY_CONTENTION</Value>
        </Entry>
      </Menu>
    </Option>
    <Option>
      <DisplayName>Mode</DisplayName>
      <Identifier>run-mode</Identifier>
      <DefaultEntry>0</DefaultEntry>
      <Menu>
        <Entry>
          <Name>Read Write</Name>
          <Value>READ_WRITE</Value>
        </Entry>
        <Entry>
          <Name>Read Only</Name>
          <Value>READ_ONLY</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>