Query script definition

Like the preceding table code, the actual queries run by the built-in standard pgbench tests are compiled into its source code, making the only way you can see them to refer to documentation such as http://www.postgresql.org/docs/current/static/pgbench.html.

The default transaction script, what's called the TPC-B (sort of) transaction when you run the test (and referred to here as the TPC-B-like transaction), issues seven commands per transaction. It looks like this inside the program:

\set nbranches :scale \set ntellers 10 * :scale \set naccounts 100000 * :scale \setrandom aid 1 :naccounts \setrandom bid 1 :nbranches \setrandom tid 1 :ntellers \setrandom delta -5000 5000 BEGIN; UPDATE pgbench_accounts SET abalance ...

Get PostgreSQL 10 High Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.