Re: pgpool Connections Distributions Among Nodes

From: Glauco Torres <torres(dot)glauco(at)gmail(dot)com>
To: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgpool Connections Distributions Among Nodes
Date: 2018-01-29 16:52:33
Message-ID: CAMd+QOSiOwHE0TOnJqgaW6z_Rkg-rsPkuJ03s--FfRXnaCEQLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
>
>
> We have 4-node cluster (1 master and 3 hot standby). We are using pgpool
> as load balancer. We have an observation where if application requests for
> 3 connections, pgpool connects to all 4 servers and I see 3 connections on
> each of them. I was expecting it have a total of 3 connections from either
> of 4 servers but I can easily see 12 connections in all.
>
>
>
> Can somebody shed some light on it.
>
>
>
> Please let me know if you need more information.
>
>
>
Hello,

Which version pgpool you are using?

How did you balance the reading by pgpool? Should all readings go to the
replicas? or reading goes to all nodes?

Regards,

Glauco Torres

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seth Goldin 2018-01-29 16:56:22 Re: Which specific flags to use for bash client applications for DaVinci Resolve?
Previous Message Adrian Klaver 2018-01-29 16:52:07 Re: pgpool Connections Distributions Among Nodes