<div dir="ltr">Hi there.<div><br></div><div>We're running PGPoolII in a Master-Slave setup with 3 servers - one being the primary and 2 as slaves.</div><div><br></div><div>We have it running in non-loadbalance mode using Postgresql Streaming replication.</div><div><br></div><div>What we've noticed though is that when a connection is opened to PGPool it is in turn opening a connection to each server - the Master and both Slaves. </div><div><br></div><div>This seems odd - and in our setup - where one of the slaves is geographically removed (distanced from the master) causes each connection to slow down dramatically.</div><div><br></div><div>Preferably we'd like to see PGPool only connect to the Master - and not the other two slaves if that can be set - or alternatively is there a way of reducing the speed impact of connecting to geo separated slave?</div><div><br></div><div>Any help or advice on dealing with this appreciated ;-)</div><div><br></div><div>Cheers!</div><div><br></div><div><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span style="border-collapse:collapse"><div><div style="font-size:13.33px"><b style="font-family:Arial">Jonathan</b></div></div></span></div></div></div></div></div>
</div></div>
<br>
--