[pgpool-general: 8162] Load testing Pgpool

Nikola(HM) nikm71 at hotmail.com
Mon May 16 12:51:35 JST 2022


Pgpool works in Kubernetes with 3 replicas. Docker image 
pgpool/pgpool:4.2.2 is used.
Client microservices that are written in Java with Hikari Pool are 
connected to the database through Pgpool.
Pgpool is used only as a load balancer and connection pool.

When doing load testing, the error "Unable to acquire JDBC Connection" 
was often experienced. We assumed that Pgpool was refusing to connect to 
the client for some reason. At the same time, there were still many free 
child processes in the Pgpool.

1. Could you comment on whether Pgpool can refuse to connect when there 
is an intensive load of a large number of clients and for what reason?

2. What are the recommendations for setting up a Pgpool running in Kuber 
to serve a large number of clients and high request rates, such as 1000 
per second?

Thanks in advance.


More information about the pgpool-general mailing list