You now that Postgres don’t have any shared_pool as Oracle, and the session information ( execution plan, etc..) are
onlyavailable for the current session. Therefore I also highly recommend to us a connection poll as Laurent wrote, in
orderto 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
>
>
>