Daulat Ram wrote:
> 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.
I'd say that is way too high in both Oracle and PostgreSQL.
Set the value to 50 or 100 and get a connection pooler if the
application cannot do that itself.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com