<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 3, 2016 at 11:14 AM, Tory M Blue <span dir="ltr"><<a href="mailto:tmblue@gmail.com" target="_blank">tmblue@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hey folks<br><br>Running into some more issues and i'm not finding a definitive tuning guide nor can I tell why i'm backing up and why it takes so long to catch up (so long is relative).<br><br><div>Running Slony 2.2.3 (but this has been an issue for a long time).</div><div><br></div><div>Image to show you where I am this AM , but this is a constant every AM. I have large updates about 2.5 million between 12am and 4am, the job is done but it will take Slon a couple of hours to catch up.</div></div></blockquote><div><br></div><div>Are there long running transactions that start around the time, the sl_log starts</div><div>growing? Any long running transaction prevents a log switch from finishing. </div><div><br></div><div><br></div><div>Jan</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><br></div><div>Hardware: big 256GB 32 Proc machines (proc's don't matter here). I see very little iowait 2% on the standby, 0% on the primary and I'm seeing a whopping 150tps coming to the secondary (I would expect it to be writing like crazy!)</div><div><br></div><div>idb01 is the primary idb02 is the secondary</div><div><br></div><div><img src="https://dl.dropboxusercontent.com/u/5962103/Misc/slony.jpg" width="462" height="412"><br><br></div><div>MY configuration settings, or those that I think matter</div><div><br></div><div>
<p><span>cleanup_interval="5 minutes"</span></p><p><span>
</span></p><p><span>sync_interval=1000</span></p><p><span>
</span></p><p><span>sync_group_maxsize=5000</span></p><p><span>
</span></p><p><span>#sync_max_rowsize=8192</span></p><p><span><br></span></p><p><span>I don't see why my primary backs up so much, I don't see the same backup on idb02 (which is replicating to 3 other servers. Those 3 servers have forward=no, so they never have anything stored in sl_log. (meaning the graphs for those are flat lined).</span></p><p>I think the only thing to really tune is sync_group_maxsize, or sync_max_rowsize maybe. I have lots of RAM, but would really like to figure out why I seem to backup, the hardware, network, disk is good, Slony should really be performing better, it has lots of resources..</p><p><br></p><p>Thanks for any ideas or where to look. Logs don't seem to tell me there is an issue.</p><span><font color="#888888"><p>-Tory</p><p><span><br></span></p></font></span></div></div>
<br>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Jan Wieck<br>Senior Postgres Architect<font color="#000000"></font></div></div><div><a href="http://pgblog.wi3ck.info" target="_blank">http://pgblog.wi3ck.info</a></div></div></div></div></div>
</div></div>