[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