Andrew Sullivan ajs at crankycanuck.ca
Fri May 11 16:09:42 PDT 2007
On Sat, May 12, 2007 at 02:47:14AM +0400, Dmitry Koterov wrote:
> So, the question is: how to make the Slony to update slaves as fast as
> possible without bombing the master with periodical queries? And - what is
> the detailed meaning of sync_interval?

There isn't a way to update the slaves as fast as possible without
the queries, although more recent code reduces the LISTEN/NOTIFY
dependency.  But this is _async_ replication.  If you want perfect
copies, it can't do what you want.  It's always going to lag some.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
Everything that happens in the world happens at some place.
		--Jane Jacobs 


More information about the Slony1-general mailing list