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
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
it 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 h
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 postgr
Hello team,
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
