<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Apple Color Emoji";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0in;
margin-bottom:.0001pt;
background:#E3E3E3;
font-size:10.0pt;
font-family:Menlo;
color:black;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Hello Slony community,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Our service has a DML-heavy task (thousands of rows moved between tables) occurring at the top of each hour. We are seeing changelog processing virtually stop on one or more subscribers for
several minutes right after this occurs. (Log samples included below.) Breaking the DML into batches (multiple transactions) does not seem to have helped. What switches (sync groups?) should we be trying out with slony 2.2.6?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Thanks in advance,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="p1"><span class="s1">2019-09-13 10:00:00 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198654 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:01 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000073045 done in 1.776 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:01 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:01 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:02 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198596 done in 0.594 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:02 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000073046 done in 1.055 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:08 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:08 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000073048 done in 1.229 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:11 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198655 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:13 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198597 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:20 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198656 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:26 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198598 done in 0.693 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:37 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198657 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:37 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198599 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:47 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198658 done in 0.650 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:47 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198600 done in 0.692 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:00:53 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198601 done in 0.594 seconds</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">…<o:p></o:p></span></p>
<p class="p1"><span class="s1">2019-09-13 10:03:03 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000198672 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:03:05 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198614 done in 0.692 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:03:10 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000073049 done in 181.070 seconds</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">…<o:p></o:p></span></p>
<p class="p1"><span class="s1">2019-09-13 10:59:54 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:59:54 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:59:54 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198955 done in 0.594 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 10:59:55 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000074842 done in 1.726 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:00 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:00 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:01 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198956 done in 0.693 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:01 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000074845 done in 1.023 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:05 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199014 done in 0.737 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:07 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:07 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:07 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000074848 done in 1.062 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">Fri Sep 13 11:00:07 UTC 2019 : SyncRateUpdate: 5000074848 2</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 2 with 5 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: syncing set 1 with 17 table(s) from provider 1</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:09 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198957 done in 0.693 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:12 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199015 done in 0.650 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:24 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198958 done in 0.736 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:24 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199016 done in 0.738 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:31 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198959 done in 0.693 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:37 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199017 done in 0.736 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:00:40 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199018 done in 0.736 seconds</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">…<o:p></o:p></span></p>
<p class="p1"><span class="s1">2019-09-13 11:04:21 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198982 done in 0.693 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:04:33 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_2: SYNC 5000199041 done in 0.736 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:04:33 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_5: SYNC 5000198983 done in 0.736 seconds</span><o:p></o:p></p>
<p class="p1"><span class="s1">2019-09-13 11:04:38 UTC [6943] INFO </span><span class="apple-converted-space">
</span><span class="s1">remoteWorkerThread_1: SYNC 5000074850 done in 269.239 seconds</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> Tom </span>
<span style="font-size:11.0pt;font-family:"Apple Color Emoji"">☺</span><span style="font-size:11.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
</body>
</html>