Re: pgbench - startup delay - Mailing list pgsql-patches

From Tom Lane
Subject Re: pgbench - startup delay
Date
Msg-id 20805.1197326050@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgbench - startup delay  (Dave Page <dpage@postgresql.org>)
Responses Re: pgbench - startup delay
Re: pgbench - startup delay
List pgsql-patches
Dave Page <dpage@postgresql.org> writes:
> Alvaro Herrera wrote:
>> I think you could get the same effect by putting the -W in PGOPTIONS (in
>> pgbench's environment).

> That's a good point. It does have the downside that it will affect the
> pgbench results - though that wouldn't actually be an issue for what I
> was doing.

Well, if you're attaching a profiler or debugger to a backend, you're
hardly gonna get unadulterated TPS readings from pgbench anyway.
I concur with Alvaro that this case seems adequately covered by
    PGOPTIONS="-W n" pgbench ...
which is what I've always used in similar situations...

            regards, tom lane

pgsql-patches by date:

Previous
From: Dave Page
Date:
Subject: Re: pgbench - startup delay
Next
From: Greg Smith
Date:
Subject: Re: pgbench - startup delay