Joseph S <jks at selectacast.net> writes:
> I notice there are frequent big gaps in time between
> "remoteHelperThread_1_1: allocate line buffers" "remoteWorkerThread_1:
> returning lines to pool". What is going on during this time?
>
> 2009-10-13 20:55:34 EDT DEBUG4 remoteWorkerThread_1: returning lines to pool
> 2009-10-13 20:55:34 EDT DEBUG4 remoteHelperThread_1_1: fetch from cursor
> 2009-10-13 20:55:34 EDT DEBUG4 remoteHelperThread_1_1: fetched 100 log rows
> 2009-10-13 20:55:34 EDT DEBUG4 remoteHelperThread_1_1: deliver 10
> lines to worker
> 2009-10-13 20:55:34 EDT DEBUG4 remoteHelperThread_1_1: allocate line buffers
> 2009-10-13 20:55:37 EDT DEBUG4 remoteWorkerThread_1: returning lines to pool

A whole bunch of INSERTs/UPDATEs/DELETEs against a subscriber :-).

This is part of the heavy-work loop that is applying changes to the
subscriber.  Each of those fetches represents 100 replicated tuples
being propagated to the subscriber.

Why the 9 second pause is a good question, though.  Not sure why
things would pause there.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"