[pgpool-general: 6270] Re: pgpool does not reuse connections

[Tatsuo Ishii]

> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp