Christopher Browne cbbrowne
Tue Jan 11 15:18:22 PST 2005
sarlav kumar wrote:

> Hi All,
>  
> I have a question regarding the time interval between the syncs. I 
> think the default value is 10 seconds. I am wondering if the 
> performance would be better or worse if this default value is reduced 
> to 1 second. Will it be better as it has to only sync the data that 
> was changed in the last one second?
> Before experimenting with it, I would like to get some opinion on 
> deciding an optimum value for the time interval.

It's definitely going to be ambiguous.

- If you cut the interval, that should mean that subscribers will be a 
little more up to date

- Cutting the interval means that there will be more SYNCs to process, 
which will involve somewhat more work

- But cutting the interval means that each SYNC is likely to be smaller, 
so that each one will involve somewhat less work

Quite a number of tradeoffs become visible just based on that set of 
considerations.

Furthermore, you have not indicated what you mean by "performance," nor 
what metrics would be involved in determining what "optimum" means.  
None of which is at all obvious.


More information about the Slony1-general mailing list