[pgpool-general: 2856] Re: PgPool connection caching/pooling not working ?

[adrien nayrat]

Thanks for your answer

2014-05-19 23:53 GMT+02:00 Tatsuo Ishii <ishii at postgresql.org>:

> No. 32 concurrent connections.
>
If there is 32 connections on pgpool side and 32 on postgres side what is
the goal of pooling?


>
>
> Database "postgres", "template1" and "regression" are treated to not
> cache any time. Please use other database name for connection cache
> testing purpose.
>
>
I created a new db "pgbench" and launch the test and I still have the same
result :

 pool_pid |     start_time      | pool_id | backend_id |   database    |
username  |     create_time     | majorversion | minorversion |
pool_counter | pool_backendpid | pool_connected
----------+---------------------+---------+------------+---------------+-----------+---------------------+--------------+--------------+--------------+-----------------+----------------
 11276    | 2014-05-20 09:35:22 | 0       | 0          | pgbench       |
postgres  | 2014-05-20 10:24:38 | 3            | 0            |
1            | 25966           | 1
 11276    | 2014-05-20 09:35:22 | 1       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
 11276    | 2014-05-20 09:35:22 | 2       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
 11276    | 2014-05-20 09:35:22 | 3       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
 28553    | 2014-05-20 08:45:22 | 0       | 0          | pgbench       |
postgres  | 2014-05-20 10:24:38 | 3            | 0            |
1            | 25972           | 1
 28553    | 2014-05-20 08:45:22 | 1       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
 28553    | 2014-05-20 08:45:22 | 2       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
 28553    | 2014-05-20 08:45:22 | 3       | 0          |
|           |                     | 0            | 0            |
0            | 0               | 0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140520/193d6284/attachment.html>