CODEWITHSUNDEEP
postgresqlconnectionmax
user2645405
user2645405

Reputation: 1

Increase Max connections in postgresql

My Server Config : CPU - 16 core RAM - 64 GB Storage : 2 TB OS : CentOs 64 Bit

I have DB and java application on the same server.

My postgres config file has the following: max_connections = 9999
shared_buffers = 6GB

However, when i check DB via show max_connections it shows only 500.

How can i increase the max_connections value ?

Upvotes: 0

Views: 2053

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247930

Either you forgot to remove the comment (#) at the beginning of the postgresql.conf line, or you didn't restart PostgreSQL.

But a setting of 500 is already much too high, unless you have some 100 cores in the machine and an I/O system to match. Use a connection pool.

Upvotes: 1

Related Questions