Max_connections limit

Daulat Ram <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <BL0PR01MB5187D60549AA20142C51891C9BE20@BL0PR01MB5187.prod.exchangelabs.com>
Hello team,

We have migrated our database  from Oracle 12c to Postgres 11. I need your suggestions , we have sessions limit in Oracle = 3024 . Do we need to set the same connection limit in Postgres as well. How we can decide the max_connections limit for postgres. Are there any differences in managing connections in Oracle and postgres.

SQL> show parameter sessions;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size           integer     0
java_soft_sessionspace_limit         integer     0
license_max_sessions                 integer     0
license_sessions_warning             integer     0
sessions                             integer     3024
shared_server_sessions               integer
SQL>

Regards,
Daulat
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.