<div dir="ltr"><br><div class="gmail_extra">Thanks for your answer<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-05-19 23:53 GMT+02:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">No. 32 concurrent connections.<br></blockquote><div>If there is 32 connections on pgpool side and 32 on postgres side what is the goal of pooling? <br>
</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div class="h5">
<br>
<br>
</div></div>Database "postgres", "template1" and "regression" are treated to not<br>
cache any time. Please use other database name for connection cache<br>
testing purpose.<br>
<br>
</blockquote></div><br>I created a new db "pgbench" and launch the test and I still have the same result : <br><br><font size="1"><span style="font-family:courier new,monospace"> pool_pid | start_time | pool_id | backend_id | database | username | create_time | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected<br>
----------+---------------------+---------+------------+---------------+-----------+---------------------+--------------+--------------+--------------+-----------------+----------------<br> 11276 | 2014-05-20 09:35:22 | 0 | 0 | pgbench | postgres | 2014-05-20 10:24:38 | 3 | 0 | 1 | 25966 | 1<br>
11276 | 2014-05-20 09:35:22 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0<br> 11276 | 2014-05-20 09:35:22 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0<br>
11276 | 2014-05-20 09:35:22 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0<br> 28553 | 2014-05-20 08:45:22 | 0 | 0 | pgbench | postgres | 2014-05-20 10:24:38 | 3 | 0 | 1 | 25972 | 1<br>
28553 | 2014-05-20 08:45:22 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0<br> 28553 | 2014-05-20 08:45:22 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0<br>
28553 | 2014-05-20 08:45:22 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0<br></span></font><br></div></div>