<div dir="ltr">Fixed sorry about that!<br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 9, 2016 at 5:50 PM, Jan Wieck <span dir="ltr"><<a href="mailto:jan@wi3ck.info" target="_blank">jan@wi3ck.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">Getting a 404 on those images.</div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 9, 2016 at 12:36 PM, 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:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><span>On Sat, Aug 6, 2016 at 6:16 AM, Jan Wieck <span dir="ltr"><<a href="mailto:jan@wi3ck.info" target="_blank">jan@wi3ck.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">How are you monitoring the number of rows in the sl_log_* tables?<div><br></div><div><br></div><div>Jan</div></div><div class="gmail_extra"><br></div></blockquote><div><br></div></span><div>I've got a couple of updates but first let me answer the question.</div><div><br></div><div><p><span> </span><span>max</span><span> => </span><span>"SHOW max_connections"</span><span>,</span></p><p><span> </span><span>cur</span><span> => </span><span>"SELECT COUNT(*) FROM pg_stat_activity"</span><span>,</span></p><p><span> </span><span>log1</span><span> => </span><span>"SELECT COUNT(*) FROM _cls.</span><span>sl_log</span><span>_1"</span><span>,</span></p><p><span> </span><span>log2</span><span> => </span><span>"SELECT COUNT(*) FROM _cls.</span><span>sl_log</span><span>_2"</span><span>,</span></p><p><span> </span><span>siz1</span><span> => </span><span>"SELECT (relpages*8) FROM pg_class where relname='</span><span>sl_log</span><span>_1'"</span><span>,</span></p><div><span> </span><span>siz2</span><span> => </span><span>"SELECT (relpages*8) FROM pg_class where relname='</span><span>sl_log</span><span>_2'"</span> </div><div><br></div><div>We have a script that runs and monitors a few things in the dB, one is the count of sl_log_1 and 2. This is added as an RRD </div><div>and graphed. </div><div><br></div><div>Now the update, graph above , is what we have been seeing, logs grow up until 10:50am or so when the truncate is allowed (now backups are complete at 4am and all heavy lifting is finished at 5am)</div><div><br></div></div><div><img src="https://dl.dropboxusercontent.com/u/5962103/Misc/Screenshot%202016-08-09%2018.15.16.jpg" width="513" height="225"><br></div><div><br></div><div>I disabled the full backup on the standby unit last night.</div><div><br></div>
<p><img src="https://dl.dropboxusercontent.com/u/5962103/Misc/Screenshot%202016-08-09%2018.17.51.jpg" width="513" height="227"><br></p><div>I still get some peeks and valleys, but the system is not backed up for 10 hours. So this tells me that the backup on the standby is causing a situation where slon is blocked because tables are locked on the standby unit. This is still not ideal but it's a big improvement from before where the sl_log_? would grow to 14million rows from about 2am to 10:45am..</div><div><br></div><div>So I need to figure out how to reduce the overhead of the backup, I figured it was better to run it on the standby but at this point that is not looking like a great option..</div><div><br></div><div>Thanks for working on this with me!</div><span><font color="#888888"><div><br></div><div>Tory</div></font></span></div></div></div><span><font color="#888888">
</font></span></blockquote></div><span><font color="#888888"><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>
</font></span></div>
</blockquote></div><br></div></div>