Some slony log info, anyone out there with slony experience ?

slony 10.1.1.2(35428) 2012-02-21 12:56:04 PST 0 LOG:  duration: 502.162 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:56:44 PST 0 LOG:  duration: 547.304 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:56:56 PST 0 LOG:  duration: 595.473 ms  statement: fetch 500 from LOG; 
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);         
slony 10.1.1.2(35428) 2012-02-21 12:57:39 PST 0 LOG:  duration: 521.751 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:58:05 PST 0 LOG:  duration:
 663.164 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:58:33 PST 0 LOG:  duration: 584.578 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:58:53 PST 0 LOG:  duration: 524.076 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:59:22 PST 0 LOG:  duration: 610.761 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 12:59:42 PST 0 LOG:  duration: 629.949 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:00:10 PST 0 LOG:  duration: 509.607 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:00:48 PST 0 LOG:  duration: 519.203 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:01:00 PST 0 LOG:  duration: 527.713 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:01:09 PST 0 LOG:  duration:
 616.263 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:01:17 PST 0 LOG:  duration: 520.641 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:02:13 PST 0 LOG:  duration: 519.352 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:02:49 PST 0 LOG:  duration: 505.472 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:03:52 PST 0 LOG:  duration: 601.902 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:04:50 PST 0 LOG:  duration: 643.636 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:06:03 PST 0 LOG:  duration: 513.065 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:06:29 PST 0 LOG:  duration: 648.466 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:07:08 PST 0 LOG:  duration:
 645.737 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:07:56 PST 0 LOG:  duration: 559.368 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:08:08 PST 0 LOG:  duration: 524.154 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:08:20 PST 0 LOG:  duration: 594.628 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:08:34 PST 0 LOG:  duration: 515.906 ms  statement: fetch 500 from LOG; 
slony 10.1.1.2(35428) 2012-02-21 13:08:48 PST 0 LOG:  duration: 535.204 ms  statement: fetch 500 from LOG; 
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); 



________________________________
 From: Brian Trudal <dbrb2002-sql at yahoo.com>
To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info> 
Sent: Tuesday, February 21, 2012 7:30 PM
Subject: [Slony1-general] Replication Lag - fetch 500 from LOG
 

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.

Anything that am missing ? 


I really appreciate some's answer...

Its on PG 8.4 + slony 2.0.4

Thanks
Brian

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120221/5f392a97/attachment.htm