PostgreSQL 10 High Performance - Third Edition

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, mtime timestamp,filler char(22)); 

Before PostgreSQL 8.4, these tables did not have the pgbench_ prefix in their names. This was ...