Simon Riggs <simon at 2ndquadrant.com> writes:
> Your earlier graphs highlight the problem very well. Chris mentions that
> the proposed solution has already been committed, based upon my
> analysis. 
>
> Re-running the tests with the latest version of the software would help
> confirm that the problem has gone away. Would you be able to repeat the
> tests to confirm that the response time no longer peaks periodically as
> it did before?

I wouldn't be surprised if it still has some periodic peaks that would
be alleviated by increasing the number of elements processed at a
time.

It may be that increasing SLON_DATA_FETCH_SIZE somewhat would be of
value.  (Well, just like the NO SCROLL cursor proposal, the value of
it would vanish if/when we implement COPY on sl_log_? data...)
-- 
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/oses.html
Donny: Are these the Nazis, Walter?
Walter: No, Donny, these men are nihilists. There's nothing to be
afraid of.  -- The Big Lebowski