Vick Khera vivek at khera.org
Mon Jul 13 08:02:59 PDT 2009
On Sun, Jul 12, 2009 at 3:39 AM, Aleksander
Kmetec<aleksander.kmetec at intera.si> wrote:
> Today I reduced the cleanup_interval back down to 10 minutes and ran the
> usual scripts. Rows went missing again. This leads me to believe that
> cleanupEvent() does indeed remove rows that are still needed.

How far behind does your replication lag when you observe the lost
rows?  I have alarms go off via nagios when our replication falls
behind by more than 180 seconds (because our customers start to
notice).  Our normal lag is not more than 5 seconds or so, but
occasionally we get up to 10+ minutes when doing maintenance cleanup
jobs.  I don't have evidence of ever losing any data.


More information about the Slony1-general mailing list