Christopher Browne cbbrowne at ca.afilias.info
Fri May 23 10:33:35 PDT 2008
"Henry" <henry at zen.co.za> writes:
> On Fri, May 23, 2008 5:23 pm, Christopher Browne wrote:
>>> case, we have a large cluster with gigabit networking, yet usage is a
>>> paltry few megabits/s (so large updates take hours to days to
>>> replicate).
>
>> I'm not sure but that maybe something's flakey with your network; that
>> would also be an explanation for the problem, and Slony-I can't
>> resolve that!
>
> :) fair enough.  Let me rephrase:  I can saturate my network with rsync,
> but Slony doesn't seem to follow suit (even bumping SLON_FETCH_DATA_SIZE).
>  I do understand, however, that pumping data between nodes isn't the only
> processing being done.

I'm just trying to be comprehensive about the possibilities ;-).  

If you can take a peek at pg_stat_activity, you may be able to track
down where the bottleneck is, which might help us help you further.
-- 
output = ("cbbrowne" "@" "cbbrowne.com")
http://cbbrowne.com/info/oses.html
"I will not be numbered, stamped, briefed, debriefed, or filed!"
-- Number Six


More information about the Slony1-general mailing list