pgbench default tests

The original inspiration for the pgbench test is the Transaction Processing Performance Council (TPC) benchmark named TPC-B: http://www.tpc.org/tpcb/.

Originally developed in 1990 (and now considered obsolete from the TPC's perspective), this benchmark models a simple bank application that includes a set of bank branches, each of which has some number of tellers and accounts.

Table definition

The main table definition SQL adds these tables:

• pgbench_branches:

CREATE TABLE pgbench_branches(bid int not null, bbalance int, filler char(88)); 
ALTER TABLE pgbench_branches add primary key (bid); 

• pgbench_tellers:

CREATE TABLE pgbench_tellers(tid int not null,bid int, tbalance int,filler char(84)); 
ALTER TABLE pgbench_tellers add primary key (tid); 

• pgbench_accounts:

CREATE TABLE pgbench_accounts(aid int not null,bid int, abalance int,filler char(84)); 
ALTER TABLE pgbench_accounts add primary key (aid);

• pgbench_history:

CREATE TABLE pgbench_history(tid int,bid int,aid int,delta int...