On May 23, 2008, at 2:05 PM, Jan Wieck wrote:

> The slony connections are all regular libpq database connections. So  
> you might test this by using psql or pg_dump running on one of those  
> subscribers, connecting to the appropriate data provider. If that  
> can utilize more bandwidth, then the problem lies within the replica  
> itself and something else must be limiting it from reading from the  
> network faster.

Every time I dig into why our replication is lagging severely (more  
than 10-15 mintues) I find that I'm spending a lot of time inside  
"FETCH 100" queries, and then a lot of time between them, as well (ie,  
applying the updates to the replica).  It feels as of pg isn't running  
at full speed, but I don't have the numbers to prove it.