Max_connections limit
От | Daulat Ram |
---|---|
Тема | Max_connections limit |
Дата | |
Msg-id | BL0PR01MB5187692FE904EA04B73699BE9BE20@BL0PR01MB5187.prod.exchangelabs.com обсуждение исходный текст |
Ответы |
RE: Max_connections limit
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: