[prev in list] [next in list] [prev in thread] [next in thread]
List: slony1-general
Subject: Re: [Slony1-general] "best practice" for clearing sl_event.
From: "Jim C. Nasby" <jnasby () pervasive ! com>
Date: 2006-03-21 12:06:03
Message-ID: 20060321120602.GR15742 () pervasive ! com
[Download RAW message or body]
Take a look in the archives for 'catching up'; there's a couple
parameters you can tweak that will help this (I don't remember what they
are off-hand).
On Sat, Mar 18, 2006 at 05:46:39PM -0500, lkv@defx.org wrote:
> Hi guys,
>
> I was wondering if there's some way to speed up the flushing
> of the sl_event table. I've about 95k of SYNC events, and I the
> amount of syncs in the sl_event doesn't seem to be going down
> by much (say 1000-2000 per 1h or so).
>
> I'm not quite sure what to tweak to achieve this, I have my
> desired_sync raised to 60s and group max size to 1000,
> but from I can see in the log file the proposed size is not getting
> more than 2.
>
> thanks in advance!
>
> l
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general@gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic