<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 7, 2016 at 2:47 PM, Steve Singer <span dir="ltr"><<a href="mailto:steve@ssinger.info" target="_blank">steve@ssinger.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">On Thu, 7 Jan 2016, Tory M Blue wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
So I'm backing up in a big way. I know what started it, "adding a new insert slave which took 13 hours to complete (indexes<br>
etc)".. But now it doesn't appear I am able to catch up. I see the slave doing what it's suppose to, get a bunch of data,<br>
truncate the sl_log files move on. But the master is having a hard time.<br>
<br>
Postgres 9.4.5 and Slony 2.2.3<br>
<br>
All other nodes don't have any errors or issues.<br>
<br>
this is Node 1 (the master)<br>
node 2 is a slave<br>
node 3-5 are query slaves with only 1 of 3 sets being replicated too.<br>
<br>
I have interval at 5 minutes and sync_group_maxsize=50<br>
<br>
Any suggestions on where to thump it. At some point this will cause issues on my master and when I see that starting, I'll<br>
have to drop node 2 again, and when i add it, it will take 13+ hours and I'll be back in the same position :)<br>
</blockquote>
<br>
Bump sync_group_maxsize to be much bigger, I'm not saying that will solve the problem but it might help(max allowed is 10,000). I'm also suspect when you say your have a sync_interval of 5 minutes, since I thought 60 seconds was the largest allowed.<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"></blockquote></blockquote><div>My apologies</div><div>
<p class=""><span class="">cleanup_interval="5 minutes" </span></p><p class="">my interval is 1000ms</p></div><div>And sync, group cites 100 is the max</div><div>
<p class=""><span class=""># Range: [0,100], default: 6</span></p>
<p class=""><span class="">sync_group_maxsize=50</span></p>
<p class=""><span class=""></span><br></p></div><div><br></div></div></div></div>