Andrew Sullivan ajs at crankycanuck.ca
Mon Feb 18 08:05:21 PST 2008
On Fri, Feb 15, 2008 at 05:28:45AM +0200, henry wrote:
> I'm using "slon -g256 -o1000" on the slaves to try and speed up
> replication, or to force it to replicate larger chunks of rows at a time.

The disadvantage is that that may actually increase the apparent lag, since
the chunks all appear in one go (so an older transaction doesn't show up
until the big lump comes in).

> Replication lag is a real deal-killer in my case.

If you need no lag at all, then an async system is probably the wrong choice
for your case.

A



More information about the Slony1-general mailing list