<br><br>
<div class="gmail_quote">On Tue, Jun 15, 2010 at 2:34 PM, Christopher Browne <span dir="ltr"><<a href="mailto:cbbrowne@ca.afilias.info">cbbrowne@ca.afilias.info</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">Hernan Saltiel <<a href="mailto:hsaltiel@gmail.com">hsaltiel@gmail.com</a>> writes:<br>> We're working to insert massive records, almos 1 millon in a single batch.<br>> This is why I'm concerned about performance issues.<br>
<br></div>OK, that certainly provides some indication of why you'd observe<br>things getting pretty "bloated," and that points the focus towards<br>your system being just plain overloaded, and away from VACUUMs or<br>
other oddities.<br><br>You should see that either:<br><br>a) The slon from the subscriber has a connection against the provider<br>that is totally busy pulling large masses of data from the provider,<br>or<br><br>b) The connection from the subscriber-managing slon process has a<br>
connection to the subscriber that is totally busy submitting<br>INSERT/UPDATE/DELETE requests.<br></blockquote>
<div> </div>
<div> </div>
<div>I'm using "bandwithd" (great open source product to check link usage!) to check the used bandwidth, is there any place where I can see how busy of INSERT/UPDATE/DELETE is the connection and/or any other parameter?</div>
<div>Thanks again, and best regards,</div>
<div> </div>
<div>HeCSa.</div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><br>If things are behaving well, then one of those two connections should<br>be the dominant bottleneck, busy all the time. And improving the<br>
speed of that would be the appropriate focus of efforts.<br>
<div>
<div></div>
<div class="h5">--<br>"cbbrowne","@","<a href="http://ca.afilias.info/" target="_blank">ca.afilias.info</a>"<br><<a href="http://dba2.int.libertyrms.com/" target="_blank">http://dba2.int.libertyrms.com/</a>><br>
Christopher Browne<br>(416) 673-4124 (land)<br></div></div></blockquote></div><br><br clear="all"><br>-- <br>HeCSa<br>