<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><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 class="gmail-p1"><span class="gmail-s1">cleanup_interval="5 minutes"</span></p><p class="gmail-p1"><span class="gmail-s1">
</span></p><p class="gmail-p1"><span class="gmail-s1">sync_interval=1000</span></p><p class="gmail-p1"><span class="gmail-s1">
</span></p><p class="gmail-p1"><span class="gmail-s1">sync_group_maxsize=5000</span></p><p class="gmail-p1"><span class="gmail-s1">
</span></p><p class="gmail-p1"><span class="gmail-s1">#sync_max_rowsize=8192</span></p><p class="gmail-p1"><span class="gmail-s1"><br></span></p><p class="gmail-p1"><span class="gmail-s1">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 class="gmail-p1">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 class="gmail-p1"><br></p><p class="gmail-p1">Thanks for any ideas or where to look. Logs don't seem to tell me there is an issue.</p><p class="gmail-p1">-Tory</p><p class="gmail-p1"><span class="gmail-s1"><br></span></p></div></div>