On Wed, Apr 13, 2011 at 10:33 AM, Vick Khera <[email protected]> wrote:
> On Wed, Apr 13, 2011 at 12:55 PM, Richard Yen <[email protected]> wrote: > >> I was wondering if there'd be any way to make that logswitch go faster (or >> perhaps more frequently)? Would anyone know how to minimize the size of >> sl_log_*? I was thinking about doing things like raising sync_interval to >> create less entries in > > > Why? Was there some observable "bad" that was resulting from it taking so > long? In particular, was your replication falling behind? > Well, I noticed that when the log gets large and it's in the middle of a logswitch, load on the origin node will increase and subsequent to that, all subscriber nodes will lag up to 900sec. This seems troublesome, considering that nodes in my cluster typically don't lag for more than 10sec--it's only during these logswitch events that they lag by so much. --Richard
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
