[Pgpool-general] Pgpool Performence with out loadbalancing

[Jaume Sabater]

On Mon, Jul 13, 2009 at 6:27 AM, Sridhar
Reddapani<sridhar.reddapani at arcs.org.au> 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"