Re: Turn off vacuum in pgbench?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tatsuo Ishii <ishii(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Turn off vacuum in pgbench?
Date: 2007-09-29 00:40:01
Message-ID: 22258.1191026401@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Tom Lane wrote:
>> 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...

> I wonder if autovacuum itself is going to add more variability to the
> test (like we don't have enough already).

Of course it will, which means that people will likely turn off autovac
when trying to obtain repeatable pgbench numbers, which is another
reason not to take out the built-in vacuum step.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-09-29 01:45:03 Re: Getting to 8.3 beta1
Previous Message Bruce Momjian 2007-09-28 23:59:57 Re: Turn off vacuum in pgbench?