On 8/27/2007 5:42 PM, David Rees wrote:
> On 8/27/07, Dan Falconer <lists_slony1-general at avsupport.com> wrote:
>> I believe that SYNCs are getting through, but some insight into the log files
>> to clarify would be great.  I've attached log files for roughly the same
>> period of time for both the master & slave.
> 
> Looks like things are running, but I would expect the number of rows
> synced up to be much larger. The log snippet of the slave log only
> synced 23 rows, and it took it 2 minutes to do so. No wonder it's not
> catching up!
> 
> Increase the max sync group size to something much larger, say 500 or
> so. Also, can you get a larger snippet from the slave's log file?

This sounds very much like the log selection code is suffering from long 
running transactions on the origin.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #