This is a simple TPC-B like benchmark of PostgreSQL.
Revision History
pts/pgbench-1.4.0 [11 Apr 2012 10:15:04 EDT] - Move back to older PostgreSQL 8.4.11 upstream server version to work around PostgreSQL 9.x issue right now dealing with the plpg
pts/pgbench-1.3.0 [27 Aug 2011 16:23:30 EDT] - Update PostgreSQL to version 9.0.4.
pts/pgbench-1.2.0 [06 Dec 2010 15:16:36 EST] - Initial import into OpenBenchmarking.org
Do not install this benchmark when running as root. The automated postgres database setup will silently error out, as it insists on being a non-root user. You can install Phoronix as root, but switch to another user to run the "/usr/bin/phoronix-test-suite install pts/pgbench" command. You can't use the benchmark after it's "installed" as root, because the "installation" is local to the user, in ~/.phoronix-test-suite/ directory, and setup will have failed if you do it as root.
Secondly, the benchmark will fail unless you create the following file:
/etc/ld.so.conf.d/postgresql.conf
..and put in it the following line(s) (where /home/YOURUSER is the home directory of the user that you are about to run the install as:
PostgreSQL pgbench
Recent Results With This Test
User Comments
Hardware Index
Product Finder
Create A Suite
Saved / Viewed Results
Centos 5.6 notes, workarounds
Do not install this benchmark when running as root. The automated postgres database setup will silently error out, as it insists on being a non-root user. You can install Phoronix as root, but switch to another user to run the "/usr/bin/phoronix-test-suite install pts/pgbench" command. You can't use the benchmark after it's "installed" as root, because the "installation" is local to the user, in ~/.phoronix-test-suite/ directory, and setup will have failed if you do it as root.
Secondly, the benchmark will fail unless you create the following file:
/etc/ld.so.conf.d/postgresql.conf
..and put in it the following line(s) (where /home/YOURUSER is the home directory of the user that you are about to run the install as:
/home/YOURUSER/.phoronix-test-suite/installed-tests/pts/pgbench-1.3.0/pg_/lib/
/home/YOURUSER/.phoronix-test-suite/installed-tests/pts/pgbench-1.3.0/pg_/lib/postgresql/
Cheers,
-Craig @ Halcyon Canada
Post by craighalcyon on 02 December 2011, 11.35.