"Manuel V?zquez Acosta" <mva.led at gmail.com> writes:
> I'm a bit concerned with performance penalties using slony. Does
> anyone can point me to some benchmarks.
>
> I managed to arrange the 89 tables into 33 replication sets. However,
> there may be some other schemas not so decoupled, and I would like to
> know what to expect.

The behaviour of a given system depends heavily on the combination of
various dynamics:

 - Firstly, how much data you are working with
 - Secondly, how heavy a load of updates it undergoes
 - Thirdly, what kind of hardware you have to support the systems

Benchmarks that are good for me may be pretty useless for you...

The usual finding has been that, under load, replication adds on the
order of a 15-20% load to the "master."  If you're so close to the
edge, performance-wise, that that is too much, then you're in trouble.

The only way to really be certain is to do some benchmarking based on
your own systems' behaviour.
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)