On Mon, Jul 13, 2009 at 6:27 AM, Sridhar Reddapani<[email protected]> wrote:
> This is my scenario, > I am having two servers, Server1 and Server2, both are located in two > different cities. > I have configured Server1 as Pgpool and Backend_host0, and Server2 as > Backend_host1. My webserver [located in same network as server1] is > connected to Pgpool for mostly read operations. > > My Problem is, > I found Pgpool responding significently faster to webserver if I it single > Backend host compared to two Backend hosts in pool, Even I am not using > Loadbalancing [load_balance_mode = false] and having backend_weight1 = 0 > in pgpool.conf is that what expected in pgpool? Is there any configuration > to improve performence of pgpool? What would you expect? IMHO, pgpool-II is not what you should be using in this scenario. You want a master server with a warm standby server. Have in mind that pgpool-II will try to get the ACK from both nodes before returning it to the client, and you're going to have high latencies with the network configuration you have. If I've understood your situation correctly, you want an active-passive cluster. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
