Mon Nov 13 07:14:47 PST 2006
- Previous message: [Slony1-general] sync events delay
- Next message: [Slony1-general] non-standard escape syntax
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
David Janssens wrote: > Hello, > > I would like to know why sync events are generated in my cluster every > 10s even when nothing changes? 1. Sequences are polled, so this keeps them up to date 2. The frequency is configurable using the "-s" and "-t" options so you may change the timing two ways > As far as i know, this causes some useless work (growing sl_event > table, network traffic between nodes, etc.) > Also i would like to know if it's possible to replicate tables as soon > as they are modified, instead of having to wait 10s. > You might use -s 1000 so that it checks every 1000ms rather than every 10000... Setting it extremely low won't be overly good - that'll make Slony-I poll for work *exceedingly* frequently, and each SYNC has some cost, so pushing through many times as many SYNCs is liable to be costly. You might also increase from the default "-t 60000" to something higher so that if no updates are coming in, SYNCs are generated less often.
- Previous message: [Slony1-general] sync events delay
- Next message: [Slony1-general] non-standard escape syntax
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list