[pgpool-general: 8146] Re: allocation of child processes is constantly growing

Tatsuo Ishii ishii at sraoss.co.jp
Wed May 11 15:29:33 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?

Please see the FAQ:

Best reagards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list