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(dot)albe(at)cybertec(dot)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
>
>
>