Thread: 9.0 beta 3 pgbench -- documentation issue

Greg,

Your current documentation examples for customs scripts in pgbench
includes the variable :scale, i.e.:

\set nbranches :scale
\set ntellers 10 * :scale
\set naccounts 100000 * :scale

However, in the documentation the variable :scale is never set,
resulting in it defaulting to 1.  The example script needs to start with:

\set scale 10

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

Josh Berkus wrote:
> However, in the documentation the variable :scale is never set,
> resulting in it defaulting to 1.  The example script needs to start with:
>
> \set scale 10
>

Look at table F-15 "pgbench benchmarking options", specifically the
section for "-s scale_factor".  That describes how the scale is set for
the internal tests, and that you need to set it manually using "-s
<scale>" for custom scripts run using "-f <script>".  My guess is that
covers the situation you ran into here.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us