Tue Mar 21 04:06:03 PST 2006
- Previous message: [Slony1-general] "best practice" for clearing sl_event.
- Next message: [Slony1-general] General slony maintenance guidelines?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 at 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 at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/slony1-general > -- Jim C. Nasby, Sr. Engineering Consultant jnasby at pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- Previous message: [Slony1-general] "best practice" for clearing sl_event.
- Next message: [Slony1-general] General slony maintenance guidelines?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list