PostgreSQL pgbench 1.2.0

pts/pgbench-1.2.0 - 06 December 2010 - Initial import into OpenBenchmarking.org

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>http://wwwmaster.postgresql.org/redir/412/h/source/v9.0.1/postgresql-9.0.1.tar.bz2, http://wwwmaster.postgresql.org/redir/56/h/source/v9.0.1/postgresql-9.0.1.tar.bz2, http://wwwmaster.postgresql.org/redir/180/f/source/v9.0.1/postgresql-9.0.1.tar.bz2, http://wwwmaster.postgresql.org/redir/118/h/source/v9.0.1/postgresql-9.0.1.tar.bz2</URL>
      <MD5>57ba57e43cfe29e16dacbf5789be98d1</MD5>
      <FileSize>13773951</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh

version=9.0.1

if [ ! -e postgresql-${version}.tar.bz2 ]; then
    echo Please download postgresql-${version}.tar.bz2 into $(pwd)
    echo "from http://www.postgresql.org/ftp/source/"
    exit 1;
fi

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

rm -rf $HOME/pg_
mkdir $HOME/pg_

cd postgresql-${version}
./configure --prefix=$HOME/pg_ --datadir=$HOME/pg_/data --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 30
# create test db
pg_/bin/createdb pgbench
# set up tables
pg_/bin/pgbench -i -s \$NUM_CPU_JOBS pgbench

# run the test 
pg_/bin/pgbench -t 30000 -c \`expr \$NUM_CPU_JOBS / 2\` pgbench >\$LOG_FILE 
# 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 v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<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 v3.0.0a3 (Iveland) [ http://www.phoronix-test-suite.com/ ]-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>PostgreSQL pgbench</Title>
    <AppVersion>9.0.1</AppVersion>
    <Description>This is a simple TPC-B like benchmark of PostgreSQL.</Description>
    <ResultScale>TPS</ResultScale>
    <Proportion>HIB</Proportion>
    <SubTitle>TPC-B Transactions Per Second</SubTitle>
    <Executable>pgbench</Executable>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.2.0</Version>
    <SupportedPlatforms>Linux, MacOSX, Solaris</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities</ExternalDependencies>
    <EnvironmentSize>230</EnvironmentSize>
    <ProjectURL>http://www.postgresql.org/</ProjectURL>
    <InternalTags>SMP</InternalTags>
    <Maintainer>Kim Bisgaard</Maintainer>
  </TestProfile>
</PhoronixTestSuite>