KubaTyszko wrote:

>connection
>Reply-To: kuba at lbl.pl
>
>hi all.
>i have two servers placed about 300KM from each other.
>both have 256kbit/s connection.
>one will be master and another will be slave.
>(master has some services like squid redirector that for each http
>request does select from database.
>will putting slony into work wslow down this squid redirector ?
>here is exactly what i mean: there is database i wish to replicate,
>master host has redirector that needs about 50-100 request to one of
>tables per second.
>updates / inserts to database are not often - they occur about every 15
>minutes.
>will installing slony slow down the redirector or not.
>did anyone ran some benchmark about this or doyou have some experience
>about similar situations?
>  
>

Well, there will be _some_ cost to running replication, but it's not 
evident that it will get directly in the way to hinder performance of 
your "Squid redirector."

If you're merely submitting queries against replicated tables, that 
doesn't add to the cost of replication.

It doesn't sound as though the scenario you are describing is one where 
Slony-I should "hurt" performance of the redirector.

If it's an important service, it would certainly warrant doing some 
performance testing so that you can get some concrete experimental 
results rather than just knowing some others "expect it to work OK."