Running a full and thorough pgbench
evaluation of a server takes several days of system runtime. Starting with PostgreSQL 8.3, the pgbench-tools
program, available from http://git.postgresql.org/gitweb?p=pgbench-tools.git, allows the automation of multiple runs of pgbench
, including the production of graphs showing the results. Earlier PostgreSQL versions did not save all the necessary information to allow the graphing results over time.
On a system that supports running the git
version control software, you can retrieve the source code like this:
$ git clone git://git.postgresql.org/git/pgbench-tools.git $ cd pgbench-tools/
If you're on a database server that doesn't support git
, you may need to run the preceding code on a newer system that does, then use that system to create an archive: here are two examples that produce a .tar
and .zip
file respectively:
$ git archive --prefix=pgbench-tools/ HEAD > pgbench-tools.tar $ git archive --prefix...