On Wed, Apr 13, 2011 at 10:33 AM, Vick Khera <vivek at khera.org> wrote:

> On Wed, Apr 13, 2011 at 12:55 PM, Richard Yen <dba at richyen.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110413/36493878/attachment.htm