Re: Max_connections limit - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: Max_connections limit
Date
Msg-id 58da191b8fbd40c5361bcb332b1defe18f03bb5a.camel@cybertec.at
Whole thread Raw
In response to Max_connections limit  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses Re: Max_connections limit  (Hervé Schweitzer (HER)<herve.schweitzer@dbi-services.com>)
List pgsql-performance
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




pgsql-performance by date:

Previous
From: Daulat Ram
Date:
Subject: Max_connections limit
Next
From: Hervé Schweitzer (HER)
Date:
Subject: Re: Max_connections limit