Re: Turn off vacuum in pgbench? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Turn off vacuum in pgbench?
Date
Msg-id 20256.1190737761@sss.pgh.pa.us
Whole thread Raw
In response to Turn off vacuum in pgbench?  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Turn off vacuum in pgbench?
Re: Turn off vacuum in pgbench?
List pgsql-hackers
Tatsuo Ishii <ishii@postgresql.org> writes:
> Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench
> should stop issuing vacuum in pgbench -i since an ordinary vacuum will
> take very long time under autovacuum running. If there's no objection,
> I will remove vacuum from pgbench.

I'd be inclined to leave it there, simply because you'll be changing
the conditions of the benchmark if you take it out.  I have not noticed
any particular problems with it...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Hash index todo list item
Next
From: Tom Lane
Date:
Subject: Re: pg_resetxlog output clarification