diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-01-29 11:49:40 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-01-29 12:05:55 +0200 |
| commit | 89d00cbe01447fd36edbc3bed659f869b18172d1 (patch) | |
| tree | 20f41b9396103089c7ddf019de3226d9ae791901 /doc/src | |
| parent | c9d7dbacd387ab3814bc6b38010a9e72a02ea4f5 (diff) | |
| download | postgresql-89d00cbe01447fd36edbc3bed659f869b18172d1.tar.gz postgresql-89d00cbe01447fd36edbc3bed659f869b18172d1.zip | |
Allow pgbench to use a scale larger than 21474.
Beyond 21474, the number of accounts exceed the range for int4. Change the
initialization code to use bigint for account id columns when scale is large
enough, and switch to using int64s for the variables in pgbench code. The
threshold where we switch to bigints is set at 20000, because that's easier
to remember and document than 21474, and ensures that there is some headroom
when int4s are used.
Greg Smith, with various changes by Euler Taveira de Oliveira, Gurjeet
Singh and Satoshi Nagayasu.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pgbench.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/pgbench.sgml b/doc/src/sgml/pgbench.sgml index 58686b1a8b5..9ed8b76963c 100644 --- a/doc/src/sgml/pgbench.sgml +++ b/doc/src/sgml/pgbench.sgml @@ -185,6 +185,11 @@ pgbench <optional> <replaceable>options</> </optional> <replaceable>dbname</> Multiply the number of rows generated by the scale factor. For example, <literal>-s 100</> will create 10,000,000 rows in the <structname>pgbench_accounts</> table. Default is 1. + When the scale is 20,000 or larger, the columns used to + hold account identifiers (<structfield>aid</structfield> columns) + will switch to using larger integers (<type>bigint</type>), + in order to be big enough to hold the range of account + identifiers. </para> </listitem> </varlistentry> |