[pgpool-general: 7944] increase in the number of connections from Pgpool to database

Nikolay Mastilo (HM) nikm71 at hotmail.com
Tue Dec 21 23:48:25 JST 2021


Hello,

Could you clarify how Pgpool works with connections. Our Java 
application has its own Hikari connection pool to connect to the 
database. By default, the minimum and maximum number of pools in Hikari 
CP is 10.

When connecting to PostgreSQL via Pgpool, the application establishes 10 
connections to the database at once. Further, on subsequent connections 
from application, the established connections are not used, but new ones 
are created. On PostgreSQL, the number of connections with the 
application is growing - 12, 15, 20 and more.

However, when the application works with PostgreSQL directly without 
Pgpool, the number of connections in the database remains 10. I would 
like to know the mechanism for managing connections in Pgpool.

Could you tell me about this or point out me please where I can read 
about it.

Thanks in advance.

-- 
Regards,
    Nikolay



More information about the pgpool-general mailing list