<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><span>Some slony log info, anyone out there with slony experience ?<br><br>sl</span><span>ony 10.1.1.2(35428) 2012-02-21 12:56:04 PST 0 LOG: <span class="yshortcuts cs4-visible" id="lw_1329890619_0">duration</span>: 502.162 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:56:44 PST 0 LOG: duration: 547.304 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:56:56 PST 0 LOG: duration: 595.473 ms statement: fetch 500 from LOG; <br>slony
10.1.1.3(52676) 2012-02-21 12:57:27 PST 0 LOG: duration: 1249.432 ms
statement: select "_slony1".cleanupEvent('10 minutes'::interval,
'false'::boolean); <br>slony 10.1.1.2(35428) 2012-02-21 12:57:39 PST 0 LOG: duration: 521.751 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:58:05 PST 0 LOG: duration:
663.164 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:58:33 PST 0 LOG: duration: 584.578 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:58:53 PST 0 LOG: duration: 524.076 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:59:22 PST 0 LOG: duration: 610.761 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 12:59:42 PST 0 LOG: duration: 629.949 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:00:10 PST 0 LOG: duration: 509.607 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:00:48 PST 0 LOG: duration: 519.203 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:01:00 PST 0 LOG: duration: 527.713 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:01:09 PST 0 LOG: duration:
616.263 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:01:17 PST 0 LOG: duration: 520.641 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:02:13 PST 0 LOG: duration: 519.352 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:02:49 PST 0 LOG: duration: 505.472 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:03:52 PST 0 LOG: duration: 601.902 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:04:50 PST 0 LOG: duration: 643.636 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:06:03 PST 0 LOG: duration: 513.065 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:06:29 PST 0 LOG: duration: 648.466 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:07:08 PST 0 LOG: duration:
645.737 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:07:56 PST 0 LOG: duration: 559.368 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:08:08 PST 0 LOG: duration: 524.154 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:08:20 PST 0 LOG: duration: 594.628 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:08:34 PST 0 LOG: duration: 515.906 ms statement: fetch 500 from LOG; <br>slony 10.1.1.2(35428) 2012-02-21 13:08:48 PST 0 LOG: duration: 535.204 ms statement: fetch 500 from LOG; <br>slony
10.1.1.3(52676) 2012-02-21 13:08:49 PST 0 LOG: duration: 582.382 ms
statement: select "_slony1".cleanupEvent('10 minutes'::interval,
'false'::boolean); <br><br></span><b><span style="font-weight:bold;"></span></b><div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Brian Trudal <dbrb2002-sql@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "slony1-general@lists.slony.info" <slony1-general@lists.slony.info> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, February 21, 2012 7:30 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Slony1-general] Replication Lag - fetch 500 from LOG<br> </font> </div> <br>
<div id="yiv915634701"><div><div style="color:#000;background-color:#fff;font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt;"><div><span>All of a sudden since a day the lag is increasing and server is not getting caught; and all I can see if "fetch 500 from LOG" from pg_stat_activity.. restarted slony across and also killed all sessions in "in transaction"; and still no luck.</span></div><div><br><span></span></div><div><span>Anything that am missing ? <br></span></div><div><br><span></span></div><div><span>I really appreciate some's answer...</span></div><div><br><span></span></div><div><span>Its on PG 8.4 + slony 2.0.4</span></div><div><br><span></span></div><div><span>Thanks</span></div><div><span>Brian<br></span></div></div></div></div><br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info"
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><br><br> </div> </div> </div></body></html>