[pgpool-general: 6269] pgpool does not reuse connections
andrey.zhidenkov at gmail.com
Fri Nov 9 20:05:41 JST 2018
We have a problem at one of our environments with pgpool. It does not
use connection pool for some reason. Application written on golang (we
use gorm which uses package https://golang.org/pkg/database/sql/)
opens connections to pgpool and executes queries. Application executes
every transaction in a separate connection. In postgresql logs I see
that pgpool constantly connects and disconnects from postgres like as
if connection pool is not used. I tried to reproduce this situation
with pgbench (option --connect) but everything is OK with it. pgpool
works with pgbench as expected - it reuses all connections and doesn't
create a new one for each transaction.
num_init_children = 100, max_pool =4. max_connections in postgres = 1000.
We tried pgpool versions 3.3.4 and 3.7.5.
With best regards, Andrey Zhidenkov
More information about the pgpool-general