Re: Max_connections limit

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Max_connections limit
Date: 2019-06-26 09:05:11
Message-ID: 58da191b8fbd40c5361bcb332b1defe18f03bb5a.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hervé Schweitzer (HER) 2019-06-26 09:15:45 Re: Max_connections limit
Previous Message Daulat Ram 2019-06-26 07:13:56 Max_connections limit