From: Daulat Ram [mailto:daulat@exponential.com]
Sent: Wednesday, June 26, 2019 3:14 AM
To: pgsql-performance@lists.postgresql.org
Subject: Max_connections limit
Hello team,
We have migrated our database from Oracle 12c to Postgres 11. I need your
suggestions , we have sessions limit in Ora
On Wed, Jun 26, 2019 at 5:16 AM Hervé Schweitzer (HER) <
herve.schweit...@dbi-services.com> wrote:
> 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
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 cach
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
