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@xxxxxxxxxxx> 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 > > >
