Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kp6wW-00035y-Cy for pgsql-admin@arkaria.postgresql.org; Tue, 15 Dec 2020 09:48:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kp6wV-0004gL-0J for pgsql-admin@arkaria.postgresql.org; Tue, 15 Dec 2020 09:48:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kp6wU-0004gE-FA for pgsql-admin@lists.postgresql.org; Tue, 15 Dec 2020 09:48:26 +0000 Received: from mail-eopbgr70047.outbound.protection.outlook.com ([40.107.7.47] helo=EUR04-HE1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kp6wM-0008Ot-Ob for pgsql-admin@lists.postgresql.org; Tue, 15 Dec 2020 09:48:25 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=V93XY1vMUUJUvI50PSulbpy9IIxvlvCHkQSwLH4doif2XYvPejaMoofnaOhWJD5ZEK75VlwbXC8HCdFf7KXn4ShTDjHlwxEWPAWYG1vty+0sINDDTPdBW5DolmYjoBnxkiY0EFFztO94zqleMKi2G5Sq6utFqW3/Q7Zz7iwau0zPPfP7qggN4dGgY1twPjx0jEK41vX1G1zRaG6idVM/EBLa5aMr6VUhevrNOzo5KQ0OyYw4fpPHiUpKjsi2ku1fTH+ljR3WwpUBGwz5M1j/Q/AL+Y/3HxD4rifaQX6dZ0Gr0wdELm7CeiGy9P2P3EKpMO2dRWw7zieh4wefyCCdMA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vHVqnrDPbedBxTlBjueVtrYxcaGh4KrDA7Ad4KBOFEM=; b=FKzxLyV8Qt6dyq3Gtz5fl0YZrBd2+ck+wQGsw8YKF9xWgA8DXTUK9HbN/qebZICJTU2/X/o0YsXaTeJ3xm/zThCO1hTw9Kzy5t2lov3Zbe78IXBs9U8ZqSAQRDPXJHc8vJXLfJPjgvBc12tcwv3hEqKrSYsVRKFDjDqs/XuUoSt+KQs6ZMHMaI99T14QkMy5FlQBdWR10/Gbov9GS1qmIFDCrONRlEVsOAj1vKClB/D8YMzvulKIDnHVi+TxHD8vc4x9I+JqWna413j6aHbsSZyhw4BJKpUIfI0YvcAcstgVJ8Zpm0SnLkgpEAf0ccbSPug+Oloei64HynORumjBfg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vHVqnrDPbedBxTlBjueVtrYxcaGh4KrDA7Ad4KBOFEM=; b=H7oTHbuEPaPTI/D3VL7KKWHGPNTa7L41rOFrlnYZGpapX4irgoeVPgAHWCfxoqGNNf6C7wcy6/5v5+tVAK0DtQ4sqGOg7o7d+hF8G1LkOZmFkNam4zzhpVPA/4roa0emagwgBbsfohivyPT48gVSCPGqxpitjtUC9Jf19M63WRU= Authentication-Results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=ucll.be; Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) by AM0P195MB0274.EURP195.PROD.OUTLOOK.COM (2603:10a6:208:b3::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3654.17; Tue, 15 Dec 2020 09:48:15 +0000 Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::c49f:bbff:861:6a02]) by AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::c49f:bbff:861:6a02%5]) with mapi id 15.20.3654.025; Tue, 15 Dec 2020 09:48:15 +0000 Message-ID: <341f1b4fd5f3353e14abf610ba676e7fe1700cbe.camel@ucll.be> Subject: Re: PostgreSQL: Number of waiting connections too high From: Wim Bertels Reply-To: wim.bertels@ucll.be To: Atul Kumar , Holger Jakobs Cc: pgsql-admin@lists.postgresql.org Date: Tue, 15 Dec 2020 10:48:13 +0100 In-Reply-To: References: Organization: UC Leuven-Limburg Content-Type: multipart/alternative; boundary="=-wdzqspD0Vn7DGnDY7hM6" User-Agent: Evolution 3.30.5-1.1 X-Originating-IP: [2a02:1811:526:1700:60e:3cff:feb0:7f7b] X-ClientProxiedBy: PR3P193CA0040.EURP193.PROD.OUTLOOK.COM (2603:10a6:102:51::15) To AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from ptr-7u36h5k51lesqlynxiz.18120a2.ip6.access.telenet.be (2a02:1811:526:1700:60e:3cff:feb0:7f7b) by PR3P193CA0040.EURP193.PROD.OUTLOOK.COM (2603:10a6:102:51::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3654.12 via Frontend Transport; Tue, 15 Dec 2020 09:48:14 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 933b6612-a1df-4dc8-7e1f-08d8a0de8b24 X-MS-TrafficTypeDiagnostic: AM0P195MB0274: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:8882; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: kdaLQBPKWcrTAjgeYLTgEGmVnaB51kVKUFPeD2T8b+hSGLUAu3khNwPRP3CFvdB9gihSmhtPILTP3ffrhFxUm3q2NNxRgZd+vOpS9zgL5kQCsj3Z7sMj262OsPenwYeNe4p/wCi5FTxsGlXZvAmDa4TdkzznHjttHhoj3/GJ/UsoRUnj+n5LIc7zkTbomhx4kHaQ7qKRH0Oi1utmg2rp3KmQjJroSZ4W3Kn1wO4m0wndN5bIzCV8LHb0/FWIEbRYCcafT9rJJ768OFmv9AT0JjfW8FkzZaKaWOygPBJl7KLaF1BQwxyYVf0TZB9H3/dpWUv/zcUW97gDINspbHNmKU2yseN0GYdVRiMWY08gUyw37VzGqTqXRWERVVGYXV6TZj4siimydyQbsm52evh8eg== X-Forefront-Antispam-Report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM9P195MB0790.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(4636009)(39840400004)(366004)(396003)(346002)(136003)(376002)(52116002)(8936002)(36916002)(6506007)(6512007)(4326008)(316002)(2616005)(966005)(110136005)(186003)(33964004)(6486002)(786003)(3450700001)(44832011)(16526019)(83380400001)(8676002)(66946007)(166002)(36756003)(5660300002)(86362001)(2906002)(478600001)(66556008)(66476007);DIR:OUT;SFP:1101; X-MS-Exchange-AntiSpam-MessageData: =?utf-8?B?YnhBdU5QdktQMmRFRDNoWFBNSTJJb0tBTlJPa1kzWnh0cnhnbks5a01zR3pW?= =?utf-8?B?U3NaV3JMbW5jdE9xeU9IMEUyTEZ2ZG9MdzVzZ0pBNHpLNUZUeUErZmI0czZR?= =?utf-8?B?NHcwREkza0VXdXpwcmY5bkRoLzk4WGR3Sm9XUkZBU2Q0KytRdENJOUR5SkFa?= =?utf-8?B?bHhqNWFEaVlHeCtIK2llMmhjVVJSWHpYZVlXR2VRUHFQMWcrV3Iwck9aOGdn?= =?utf-8?B?bGU2a1ZXWGNOMGlBbENSWHloaFBQMGhrbUZZTG1sZmZUcm0yVjZ2dGpFWWJx?= =?utf-8?B?ZWo5YmNVMEp5Rk52TGxqRFB1YXZSR1dXSEVHK1JyYk0reWNSUUtJU2N1by9I?= =?utf-8?B?c1dLVFV4aDRwKzdvbUhiRnNqb1R2TEYrOGtKZFdZMDJWdWNGOEViZHNDUlRS?= =?utf-8?B?clMreE1kYUFEb3NKcDA5RVRJcVlmS3BPUEJCV1RacU9ZME8rUnpoNmRkMFV6?= =?utf-8?B?dmY5bWphMGhiRXFndnZhbUJwRFZUNWhlc2VDMUVrZ1RiVlV4RTJaN3h2SXZK?= =?utf-8?B?d3Z5aDFpc0YrR0lDMXBGcmtXTE5DVSsyQkduZFM5MHpSMFJDQUFBRjAvQkF5?= =?utf-8?B?bHNsU05GbERxZC81c21OSEd3MDFsOE52OFI3MkQvalBOVTUzbEQ1NmRTUzFy?= =?utf-8?B?dHNCcmhqc1pGSVh4MDVzblFVcTBSOG5xc3gzQlFseEg3QVExaGZ6RVl0K2hF?= =?utf-8?B?NXcvRHd6azRlQ2J1UFMvUVh0emF4VDhMSFZSRXI0TVBzVUhZQnJjeWtIN0Jx?= =?utf-8?B?UUhNTWZBVmZiTGRQcG5lTEhYOVlqY3VvdDA3ZkZIbFdKRXZvcDZwSmVCM1hJ?= =?utf-8?B?c2hJZXJRTFE5bHFMbDZuWXRRaGlVbGdHWDdMN1FQV0JFOXgwRGlDeTF0Mm84?= =?utf-8?B?enZPVmUrUzNDTWhBajhjZzMrMVAwVWJpTnRwUlVHR0h5aWI1VGJiem1PUkUv?= =?utf-8?B?VmJzQ3VISCtHTllpNnprbjFJVHlOOWdPRmgvMXhxUHFTN0J2TVk2b2NySTIy?= =?utf-8?B?N0lPY0dlUXlNbU9obVFjd3N5d2I1RTRhK3ZvakhpR3c3V2x6RlVyTXRKWHQz?= =?utf-8?B?eTZKeGI3ciswQXhYVm0zTll6WGRWQUVtVE5SRy9KamZCZ0lyc1hMZmtGS1lE?= =?utf-8?B?Z3FmUDlObVBhZXlCNjhKbHA4UHZVZ2EyWDNTZzMyUkZXSzRjbnA0YU5BbnJk?= =?utf-8?B?RE1NU3FYWkorNXY0SEZ2WFFtbWlBTGlBRHkxK0JveGNxZGdTK2gxZXBLRjlD?= =?utf-8?B?WWMvMVFkTnV5VElsTDUzZmU5OGRBeWFUVFJFVjlWWENYUUxuNVVIcHV5S3Ar?= =?utf-8?B?ME1tVXFySkRBTXE3T3M1aWNyYlBlTmloNDlWSnhoYjZuVnRxamJ2QlhkSjZo?= =?utf-8?B?Zmx1cWVCdUlaRGhMeGhYTklkMnpZanZXSjcrVHNBU3k4cys4SDA3MUYzTFFB?= =?utf-8?Q?qs5N0sr+?= X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-AuthSource: AM9P195MB0790.EURP195.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 15 Dec 2020 09:48:14.9508 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-Network-Message-Id: 933b6612-a1df-4dc8-7e1f-08d8a0de8b24 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: +ATArsVhxby+4/tTTTlLdNJm21ndneiKxUAEjtNWV9zbJT2FqjPv07gZFp9misy8mRJRFD+6HKLUNTKbBUIc8w== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P195MB0274 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-wdzqspD0Vn7DGnDY7hM6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit Atul Kumar schreef op di 15-12-2020 om 15:03 [+0530]: > Hi, > > The max_connections are 5000. > > but I am getting the alert on mere 500 connections. have a look a connection pooling Atulor https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serverhttps://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling > Please suggest why is this happening. > > > > Regards, > Atul > > > > > On 12/15/20, Holger Jakobs wrote: > > Hi, > > > > TCP maintains a backlog of waiting connections if a server > > application > > doesn't accept or deny connections. > > > > PostgreSQL has a setting max_connections, so it won't accept any > > more. > > > > So there are two solutions: > > > > * Lower the number of concurrent clients > > * Increase the max_connections setting in postgresql.conf > > > > Regards, > > > > Holger > > > > Am 15.12.20 um 10:15 schrieb Atul Kumar: > > > HI, > > > > > > I have postgres with 11.8 version. > > > > > > I am getting below error of > > > PostgreSQL: Number of waiting connections too high. > > > > > > Please help me in solving this situation. > > > > > > > > > > > > Regards, > > > Atul > > > > > > > > -- > > Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 > > > > -- mvg, Wim Bertels -- https://coronalert.be Lector UC Leuven-Limburg -- Consider well the proportions of things. It is better to be a young June-bug than an old bird of paradise. -- Mark Twain, "Pudd'nhead Wilson's Calendar" --=-wdzqspD0Vn7DGnDY7hM6 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
Atul Kumar schree= f op di 15-12-2020 om 15:03 [+0530]:
Hi,

The max_connections are 5000.

<= /div>
but I am getting the alert on mere 500 connections.

have a look a connection pooling Atul
or=


Please suggest why is this happening.



Regards,
Atul<= /div>




On 12= /15/20, Holger Jakobs <holger@jakob= s.com> wrote:
Hi,
TCP maintains a backlog of waiting connections if a server appl= ication
doesn't accept or deny connections.

<= div>PostgreSQL has a setting max_connections, so it won't accept any more.<= /div>

So there are two solutions:

  * Lower the number of concurrent clients
  * Incre= ase the max_connections setting in postgresql.conf

Regards,

Holger

Am 15.12= .20 um 10:15 schrieb Atul Kumar:
HI,

I have postgres with 11.8 version.

I am getting below error of
PostgreSQL: Number of waitin= g connections too high.

Please help me in solving = this situation.



Rega= rds,
Atul


--=
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012




-- 
mvg,
Wim Bertels
--
https://coronalert.be

Lector
UC Leuven-Limburg
--
Consider well the proportions of things.  It is better to be a young June-b=
ug
than an old bird of paradise.
		-- Mark Twain, "Pudd'nhead Wilson's Calendar"
--=-wdzqspD0Vn7DGnDY7hM6--