![[첫화면으로]](/raymundo_logo.jpg){kind=logo}
Pgpool2Pgpool2| -1,6 +1,7 |
| == # 설정 == |
| 참고: |
| * [http://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html Connections and Authentication] |
| * [https://pgpool.net/mediawiki/index.php/FAQ FAQ - pgpool Wiki] |
| * [https://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections Relationship between max pool, num init children, and max connections - pgpool Wiki] |
| <code>num_init_children</code> |
num_init_children
\c 다른DB로 전환하려고 해도 새 연결을 먼저 만들어야 하기 때문에 아예 수행이 안 됨
pgpool: wait for connection request라는 이름으로 존재
max_pool
max_pool*num_init_children <= (max_connections - superuser_reserved_connections) (no query canceling needed) max_pool*num_init_children*2 <= (max_connections - superuser_reserved_connections) (query canceling needed)