<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>According to the postgresql documentation, max_connections is the maximum number of concurrent connections to the database server, but I don't understand why max_connections must satisfy the formula max_pool * num_init_children <= (max_connections - superuser_reserved_connections), if num_init_children is also the concurrent connections limit to pgpool-II from clients and max_pool is the maximum number of cached connections in pgpool-II children processes. I am confuse with these parameters and I'll apreciate some answer.<br><br>Thank you very much for your time.<br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">What is max_connections actually?<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese: http://www.sraoss.co.jp<br><br>> I have a doubt about this. If pgpool-II only accepts 350 connections simultaneously, Why max_connections in postgresql.conf should be <br>> max_pool * num_init_children <= (max_connections - superuser_reserved_connections) <br>> <br>> Regards. <br>> ----- Mensaje original -----<br>> <br>>> > On 15/05/12 15:24, Tatsuo Ishii wrote:<br>>> >> Yes, no swap in/out and almost see no activies.<br>>> >><br>>> >><br>>> >> If you lower num_init_children, do you see any performance<br>>> >> improvement?<br>>> >><br>>> > Weird, I've tried with num_init_children = 350, keeping max_pool =<br>>> > 2,<br>>> > and it seems working!<br>>> > 350*2 = 750, how it can handle 1000 connections?<br>> <br>>> It simply does queueing. pgpool-II uses listen(2) to accept incoming<br>>> connection requests from clients. If num_init_children = 350, then<br>>> pgpool-II can accept simulately 350 connections (not 350*2 = 700).<br>>> The<br>>> 350+1 th incoming connection will be delayed in the kernel queue<br>>> until<br>>> one of 350 existing connections is terminated thus it starts to<br>>> accept<br>>> new connection.<br>>> --<br>>> Tatsuo Ishii<br>>> SRA OSS, Inc. Japan<br>>> English: http://www.sraoss.co.jp/index_en.php<br>>> Japanese: http://www.sraoss.co.jp<br>>> _______________________________________________<br>>> pgpool-general mailing list<br>>> pgpool-general@pgpool.net<br>>> http://www.pgpool.net/mailman/listinfo/pgpool-general<br>> <br>>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS<br>>> INFORMATICAS...<br>>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>> <br>>> http://www.uci.cu<br>>> http://www.facebook.com/universidad.uci<br>>> http://www.flickr.com/photos/universidad_uci<br>> <br>> <br>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>> <br>> http://www.uci.cu<br>> http://www.facebook.com/universidad.uci<br>> http://www.flickr.com/photos/universidad_uci<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>