o How to install pgbench

(1)Edit the first line in Makefile

(1)Configure and build the standard Postgres distribution.

POSTGRESHOME = /usr/local/pgsql

You can get away with just running configure at the top level

and doing "make all" in src/interfaces/libpq.

so that it points to thedirectory where PostgreSQL installed.

(2) Run make in thisdirectory.

(3) Run make. You will see an executable file "pgbench" there.

"make install".

o How to use pgbench?

where <dbname> is the name of database. pgbench uses four tables

accounts, branches, history and tellers. These tables will be

destroyed. Be verycarefully if you have tables having same

destroyed. Be verycareful if you have tables having same

names. Default test data contains:

table# of tuples

-p port

the port number that the backend is accepting. default is

5432.

libpq's default, usually5432.

-c number_of_clients

Number of clients simulated. default is 1.

-v

Do vacuuming before testing. This will take some time.

Without both -nand -v pgbench will vacuum tellers and

With neither -nnor -v, pgbench will vacuum tellers and

branches tables only.

-S