Re: pgbench -f and vacuum

On Mon, Dec 22, 2014 at 6:55 PM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> Here's a completely different idea.  How about we add an option that
> means "vacuum this table before running the test" (can be given several
> times); by default the set of vacuumed tables is the current pgbench_*
> list, but if -f is specified then the default set is cleared.  So if you
> have a -f script and want to vacuum the default tables, you're forced to
> give a few --vacuum-table=foo options.  But this gives the option to
> vacuum some other table before the test, not just the pgbench default
> ones.

Well, really, you might want arbitrary initialization steps, not just
vacuums.  We could have --init-script=FILENAME.  Although that might
be taking this thread rather far off-topic.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company