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

[Tatsuo Ishii]

>> 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
num_init_children.

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