<br><br>
<div class="gmail_quote">On Mon, Jun 14, 2010 at 5:01 PM, Scott Marlowe <span dir="ltr"><<a href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">On Mon, Jun 14, 2010 at 9:56 AM, Dhaval Jaiswal<br>
<div class="im"><<a href="mailto:bablu_postgres@yahoo.com">bablu_postgres@yahoo.com</a>> wrote:<br>><br></div>
<div class="im">> I am working on PostgreSQL 8.0.2. with slony I.<br>><br>> Whenever there is a update, insert, delete happened on primary it will take<br>> some time to replicate the same on slave. We came to know about this using<br>
> sl_status table, where its lagging time showing 1 hr or 2 hrs. However,<br>> sl_confirm table shows last replicated events is before 5 mins.<br>> We have also seen there is vacuum analyze running on replications schema.<br>
<br></div>Happens to me when there's too much IO for my hardware (which is quite<br>a bit on my hardware).<br></blockquote>
<div> </div>
<div>How can I meassure how much is too much use of my hardware when Slony is in place? </div>
<div>I can meassure the CPU, memory, disk IO, and network use, but how much is needed in order to let Slony work well?</div>
<div>Is there any way to calculate this on a transaction number and size basis?</div>
<div>Thanks!</div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im"><br>> Can someone point me where should i look into and how to improve replication<br>> performance.<br><br></div>More / faster drives and controllers.<br>
<div class="im"><br>> As of now there is no chance for upgradation of version.<br><br></div>That would be the first thing I'd recommend. Since you can't do it,<br>you're gonna have to have faster hardware, specifically the IO<br>
subsystem.<br>
<div>
<div></div>
<div class="h5">_______________________________________________<br>Slony1-general mailing list<br><a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>HeCSa<br>