CODEWITHSUNDEEP
postgresql
bcrd
bcrd

Reputation: 11

How to increase the max connections in Postgres 12?

What parameters and how should be changed in postgresql.conf to increase the maximum number of connections to 3000 if the RAM is 60GB?

Upvotes: 1

Views: 4037

Answers (1)

Pooya
Pooya

Reputation: 3183

To increase connection, you should change max_connections

But I suggest you use the website https://pgtune.leopard.in.ua/#/, This website help you config Postgres server

PS:

in my opinion, don't increase connection to 3000 because if you increase connection, database work memory decreased for each client, you can use pgbouncer

Pgbouncer is the proxy and connection manager when you have too many clients to connecting to the database, this proxy handle clients and create a pool connection

Upvotes: 1

Related Questions