| From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Max_connections limit |
| Date: | 2019-06-26 06:17:57 |
| Message-ID: | BL0PR01MB5187692FE904EA04B73699BE9BE20@BL0PR01MB5187.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ahmed, Nawaz (Fuji Xerox Australia) | 2019-06-26 07:00:04 | RE: Max_connections limit |
| Previous Message | Adrian Klaver | 2019-06-26 00:19:31 | Re: Need a referential constraint to a non-unique record |