I am trying to tune postgre to allow many concurrent queries from clients as i am checking how many parallel connections with there queries it can handle.
I read A good PgPool II configurataion , but what really can help to handle many concurrent connections with queries is to set up (num_init_children = 1000 , for example 1000 parallel queries )
If i set up num_init_children = 2000 server fails to start.
My pgpool config is:
num_init_children = 1000 max_pool = 4 child_life_time = 120 child_max_connections = 100 connection_life_time = 120 client_idle_limit = 10
How can i increase num_init_children or tune some parameters to allow 2, 5 or 10k parallel queries at the same time, cause it's really frustrating that postgre stucks with more that 1000 queries?