Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Date
Msg-id 20130722164416.GC3795@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
List pgsql-hackers
Greg Smith wrote:

Thanks.  I didn't look at the code, but while trying to read the docs:

> +        <para>
> +         High rate limit schedule lag values, that is values not small with
> +         respect to the actual transaction latency, indicate that something is
> +         amiss in the throttling process.

I couldn't really parse the above.  Of the first six words, which one is
a verb?  Is there a noun that needs to be plural?  Is there a word that
shouldn't be there?

... Oh, I think it makes sense if I assume that "rate limit schedule lag"
is a single concept .. but if so, that phrase seems too many words for it.
(So when the RLSL values are high, this indicates a problem.  Is that
what the above means?)

Also, it took me a while to understand what "values not small" means.  I
think there must be a way to phrase this that's easier to understand.

>                                            High lag can highlight a subtle
> +         problem there even if the target rate limit is met in the end.  One
> +         possible cause of schedule lage is insufficient pgbench threads to
> +         handle all of the clients.

typo "lage" above.

>                                       To improve that, consider reducing the
> +         number of clients, increasing the number of threads in pgbench, or
> +         running pgbench on a separate host.  Another possibility is that the
> +         database is not keeping up with the load at some point.  When that
> +         happens, you will have to reduce the expected transaction rate to
> +         lower schedule lag.
> +        </para>

Thanks

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [PATCH] pgbench --throttle (submission 7 - with lag measurement)
Next
From: Greg Stark
Date:
Subject: Re: improve Chinese locale performance