Re: Turn off vacuum in pgbench?

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(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-25 16:46:22
Message-ID: 2e78013d0709250946t7d667ea5l1c9c266f403c876b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 9/25/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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...

The only problem I faced is while executing custom scripts using pgbench.
You either need to do the initialization (pgbench -i) or run with -n option
(no vacuum). But I don't have any strong preference here.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2007-09-25 17:01:47 Re: Turn off vacuum in pgbench?
Previous Message Simon Riggs 2007-09-25 16:44:53 Re: pg_resetxlog output clarification