[pgpool-general: 6270] Re: pgpool does not reuse connections
ishii at sraoss.co.jp
Fri Nov 9 22:54:02 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.
> Any ideas?
No idea so far. Can you share pgpool log? 3.7.5 is preferable as 3.3
is already EOL.
SRA OSS, Inc. Japan
More information about the pgpool-general