Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)

From: Fabien COELHO <fabien(dot)coelho(at)mines-paristech(dot)fr>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: greg(at)2ndQuadrant(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Date: 2013-07-18 08:10:17
Message-ID: alpine.DEB.2.02.1307180950310.3991@localhost6.localdomain6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello again Tatsuo,

> For your information, included is the patch against git master head to
> implement the lag in a way what I proposed. With the patch, I get more
> consistent number on Linux (and Mac OS X).

I must disagree with your proposal: At least, it does not provide the
information I want, but another one.

ISTM that this patch measures the lag which is due to pgbench thread
coming around to deal with a transaction after sleeping. I would expect
that to be quite small most of the time, so I agree that it must be
reassuringly consistent.

However it does not provide the information I want, which is the measure
of the health of pgbench with respect to the stochastic process scheduled
transactions.

Basically you propose a partial lag measure, which will be smaller, but
which does not tell whether pgbench is able to follow the schedule, which
is the information I find useful in this context to appreciate if the
throttling is going well.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2013-07-18 08:24:11 Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Previous Message Bruce Momjian 2013-07-18 08:01:22 Re: pgindent behavior we could do without