[pgpool-general: 8162] Load testing Pgpool
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
Thanks in advance.
More information about the pgpool-general