Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
7-Zip Compression
SVT-AV1
FFmpeg
PostgreSQL
Stockfish
Newest Tests
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
GROMACS
Recently Updated Tests
Apache CouchDB
PostgreSQL
NAMD
Apache Cassandra
Opus Codec Encoding
ParaView
New & Recently Updated Tests
Recently Updated Suites
Database Test Suite
Machine Learning
Steam
New & Recently Updated Suites
Component Benchmarks
CPUs / Processors
GPUs / Graphics
OpenGL
Disks / Storage
Motherboards
File-Systems
Operating Systems
OpenBenchmarking.org
Corporate / Organization Info
Bug Reports / Feature Requests
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>