[pgpool-general: 4259] Question about num_init_children and max_pool

aegir at free.fr aegir at free.fr
Tue Dec 22 22:10:20 JST 2015


Hello,

Something doesn't sound clear to me with pgPool configuration.

Let's say it's configured with :

num_init_children = 2
and 
max_pool = 4

while the postmasters are configured with max_connections=10

How many "psql  -p 9999 -U user_1 DB_1" could I run from terminals without beig blocked ? 2, 8 or 10 ?

IMHO, according the available documentation I should'nt be blocked because as I use always same user/db pgPool is supposed to reuse always the same connection in each child pool, so the 11th concurrent connexion should be rejected (not blocked) due to the max_connections limit.

But by running some tests, it seems that the 3rd connection is blocked.

Could you please give me any clue about the expected behaviour ?

Thank you.


More information about the pgpool-general mailing list