Joseph S <[email protected]> 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" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
