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. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/46b2b7e0ff06498d51ebf08871c73e5b5e0aa050 Modified Files -------------- contrib/pgbench/pgbench.c | 21 +++++++++++++-------- doc/src/sgml/pgbench.sgml | 9 +++++++++ 2 files changed, 22 insertions(+), 8 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
