I suggest you to use database pooler like pgbouncer and make pool_mode=transaction for more details https://www.pgbouncer.org/features.html

how to install https://medium.com/swlh/pgbouncer-installation-configuration-and-use-cases-for-better-performance-1806316f3a22