Re: pgpool Connections Distributions Among Nodes - Mailing list pgsql-general

From Glauco Torres
Subject Re: pgpool Connections Distributions Among Nodes
Date
Msg-id CAMd+QOSiOwHE0TOnJqgaW6z_Rkg-rsPkuJ03s--FfRXnaCEQLw@mail.gmail.com
Whole thread Raw
In response to pgpool Connections Distributions Among Nodes  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
Responses RE: pgpool Connections Distributions Among Nodes  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgpool Connections Distributions Among Nodes
Next
From: Seth Goldin
Date:
Subject: Re: Which specific flags to use for bash client applications forDaVinci Resolve?