pgpool Connections Distributions Among Nodes - Mailing list pgsql-general

From Kumar, Virendra
Subject pgpool Connections Distributions Among Nodes
Date
Msg-id 05f2efb3ab16431588411c93c42e7e9e@USFKL11XG20CN01.mercer.com
Whole thread Raw
Responses Re: pgpool Connections Distributions Among Nodes  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: pgpool Connections Distributions Among Nodes  (Glauco Torres <torres.glauco@gmail.com>)
Re: pgpool Connections Distributions Among Nodes  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-general

Hi Gurus,

 

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.

 

Regards,

Virendra

 




This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.

pgsql-general by date:

Previous
From: Konstantin Gredeskoul
Date:
Subject: Re: PG Sharding
Next
From: Pritam Barhate
Date:
Subject: Using AWS ephemeral SSD storage for production database workload?