[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