Re: Max_connections limit

You now that Postgres don’t have any shared_pool as Oracle, and the  session information ( execution plan, etc..) are only available for the current session. Therefore I also highly recommend to us a connection poll as Laurent wrote, in order to have higher chance that some stuff is already cached in the shared session available. 

Regards
Herve 



Envoyé de mon iPhone

> Le 26 juin 2019 à 11:05, Laurenz Albe <laurenz.albe@cybertec.at> a écrit :
> 
> 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
> 
> 
>