Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group