On 10/5/2004 1:13 AM, Narasimha.Sridhar at cybernetsoft.com wrote:

> 
> 
> 
> Hi
> 
> I installed slony replication setup as per the documentationa and
> everything
> is working fine. But when the replication happens for the first time,
> replication takes
> 40 Secs (app.) and from second time onwards its bit fast (3 Secs app.). Can
> anybody
> explain me why is this so and is there anyway of improving that???

The first ever done SYNC after a SUBSCRIBE against the origin has a 
slightly more complicated selection. In theory, it should be possible to 
simplify that into the snapshot information of the client transaction 
that did the COPY operations to eliminate the action sequence list from 
that query.

But this is the kind of work that requires a complete understanding of 
the entire system including the algorithms. And I am looking at starting 
on multimaster any time soon. Someone else has to do that therefore, so 
better not hold your breath.


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 #