[pgpool-general: 5797] Re: pgpool connection formula

Tatsuo Ishii ishii at sraoss.co.jp
Wed Nov 1 08:18:04 JST 2017

>> a ment databas clusters. PostgreSQL instances .
> Oh, I see. Good point.

Correction: the following fomula is still correct.

max_pool*num_init_children <= (max_connections - superuser_reserved_connections) 

This is not correct. (n is the number of PostgreSQL servers (clusters
or instances in another word) managed by Pgpool-II).

max_pool*num_init_children <= (n*max_connections - superuser_reserved_connections)

The reason why n does not matter is, each Pgpool-II child process
creates automatically independent sockets to each PostgreSQL servers
(for up to 128 servers). The number of those sockets is not limited by

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

More information about the pgpool-general mailing list