[pgpool-general: 5797] Re: pgpool connection formula
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
SRA OSS, Inc. Japan
More information about the pgpool-general