On Tue, Jun 15, 2010 at 2:34 PM, Christopher Browne <
cbbrowne at ca.afilias.info> wrote:

> Hernan Saltiel <hsaltiel at gmail.com> writes:
> > We're working to insert massive records, almos 1 millon in a single
> batch.
> > This is why I'm concerned about performance issues.
>
> OK, that certainly provides some indication of why you'd observe
> things getting pretty "bloated," and that points the focus towards
> your system being just plain overloaded, and away from VACUUMs or
> other oddities.
>
> You should see that either:
>
> a) The slon from the subscriber has a connection against the provider
> that is totally busy pulling large masses of data from the provider,
> or
>
> b) The connection from the subscriber-managing slon process has a
> connection to the subscriber that is totally busy submitting
> INSERT/UPDATE/DELETE requests.
>


I'm using "bandwithd" (great open source product to check link usage!) to
check the used bandwidth, is there any place where I can see how busy of
INSERT/UPDATE/DELETE is the connection and/or any other parameter?
Thanks again, and best regards,

HeCSa.


>
> If things are behaving well, then one of those two connections should
> be the dominant bottleneck, busy all the time.  And improving the
> speed of that would be the appropriate focus of efforts.
>  --
> "cbbrowne","@","ca.afilias.info"
> <http://dba2.int.libertyrms.com/>
> Christopher Browne
> (416) 673-4124 (land)
>



-- 
HeCSa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100615/e70f67ae/attachment.htm