Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hg3rq-0008C5-83 for pgsql-performance@arkaria.postgresql.org; Wed, 26 Jun 2019 09:05:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hg3rm-0005jF-UH for pgsql-performance@arkaria.postgresql.org; Wed, 26 Jun 2019 09:05:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hg3rm-0005bi-J4 for pgsql-performance@lists.postgresql.org; Wed, 26 Jun 2019 09:05:22 +0000 Received: from mx1.mailbox.org ([2001:67c:2050:104:0:1:25:1]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hg3rk-0005gA-41 for pgsql-performance@lists.postgresql.org; Wed, 26 Jun 2019 09:05:21 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [IPv6:2001:67c:2050:105:465:1:1:0]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id B41A54FFAC; Wed, 26 Jun 2019 11:05:16 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp1.mailbox.org ([80.241.60.240]) by hefe.heinlein-support.de (hefe.heinlein-support.de [91.198.250.172]) (amavisd-new, port 10030) with ESMTP id 9oynFb0tcH76; Wed, 26 Jun 2019 11:05:12 +0200 (CEST) Message-ID: <58da191b8fbd40c5361bcb332b1defe18f03bb5a.camel@cybertec.at> Subject: Re: Max_connections limit From: Laurenz Albe To: Daulat Ram , "pgsql-performance@lists.postgresql.org" Date: Wed, 26 Jun 2019 11:05:11 +0200 In-Reply-To: References: Organization: Cybertec Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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