Re: pgbench -f and vacuum - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pgbench -f and vacuum
Date
Msg-id CA+TgmoaV32PJB+-Oi8tvAq6hhP_YoTL6795BWLKatGr_didJ+Q@mail.gmail.com
Whole thread Raw
In response to Re: pgbench -f and vacuum  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: pgbench -f and vacuum  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Initdb-cs_CZ.WIN-1250 buildfarm failures
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Proposal "VACUUM SCHEMA"