| From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
|---|---|
| To: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Max_connections limit |
| Date: | 2019-06-26 07:13:56 |
| Message-ID: | BL0PR01MB5187D60549AA20142C51891C9BE20@BL0PR01MB5187.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 | Laurenz Albe | 2019-06-26 09:05:11 | Re: Max_connections limit |
| Previous Message | Justin Pryzby | 2019-06-25 16:23:38 | Re: Perplexing, regular decline in performance |