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.a...@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 > > >
