[pgpool-general: 8145] allocation of child processes is constantly growing
Nikola(HM)
nikm71 at hotmail.com
Wed May 11 15:20:05 JST 2022
Hello,
We are running an application in Kubernetes. Pgpool also works in
Kubernetes. Each microservice has its own PostgreSQL database.
Microservices are written in Java and connect to their databases via
Pgpool .
We have a very hot issue with Pgpool.
Even in quiet mode, when there is no activity, the number of busy child
processes and, accordingly, connections to databases is constantly
growing on PostgreSQL and on and does not decrease, reaching the limit.
It turns out that microservices make new connections to the database
each time through a new child process, and do not reuse the existing one.
Could you please tell me why this is happening.
Explain, please, the mechanism of allocation of child process in Pgpool
for client connections.
When an existing client connection to a child process is reused and when
not?
Thanks in advance.
--
Regards,
Nikola
More information about the pgpool-general
mailing list