diff options
| author | Robert Haas <rhaas@postgresql.org> | 2012-07-23 14:38:34 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2012-07-23 14:42:35 -0400 |
| commit | 46b2b7e0ff06498d51ebf08871c73e5b5e0aa050 (patch) | |
| tree | 8d8d38ccc33c4fb6a3c26b6d963a3cdec41f17f7 /doc/src | |
| parent | b71258af5613e627bb2b3b1e1874abe5c0226dc4 (diff) | |
| download | postgresql-46b2b7e0ff06498d51ebf08871c73e5b5e0aa050.tar.gz postgresql-46b2b7e0ff06498d51ebf08871c73e5b5e0aa050.zip | |
Make pgbench vacuum before building indexes.
This is apparently faster than doing things the other way around when
the scale factor is large.
Along the way, adjust -n to suppress vacuuming during initialization
as well as during test runs.
Jeff Janes, with some small changes by me.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pgbench.sgml | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/src/sgml/pgbench.sgml b/doc/src/sgml/pgbench.sgml index 5ce66a6ac04..437fceab2e4 100644 --- a/doc/src/sgml/pgbench.sgml +++ b/doc/src/sgml/pgbench.sgml @@ -158,6 +158,15 @@ pgbench <optional> <replaceable>options</> </optional> <replaceable>dbname</> </varlistentry> <varlistentry> + <term><option>-n</option></term> + <listitem> + <para> + Perform no vacuuming after initialization. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-F</option> <replaceable>fillfactor</></term> <listitem> <para> |