Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gClbG-00006n-H3 for pgsql-admin@arkaria.postgresql.org; Wed, 17 Oct 2018 13:10:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gClbE-0005DZ-Vb for pgsql-admin@arkaria.postgresql.org; Wed, 17 Oct 2018 13:10:56 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1gCeoJ-0000UB-Bi for pgsql-admin@lists.postgresql.org; Wed, 17 Oct 2018 05:55:59 +0000 Received: from sender-c7.zoho.com ([135.84.80.193]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gCeoF-0006EC-7L for pgsql-admin@postgresql.org; Wed, 17 Oct 2018 05:55:58 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1539755750; cv=none; d=zoho.com; s=zohoarc; b=NbLBylESFJMWkBXaJpk1oUEJ2obe8eizo28jUv6NEC/WwVHf+Ft7g6sxeGwByPqNzP+M65nzinNSxbT0OY2tBifwAmS3kBGYke6rxjWO4tBiljnArjshALcZp2ucCVQewfmUAGRQS/liM1JEcjQ+iVcrKNa/9k9HwLzLDD+kPqY= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zoho.com; s=zohoarc; t=1539755750; h=Content-Type:Date:From:MIME-Version:Message-ID:Subject:To:ARC-Authentication-Results; bh=aSIwQPPp7EBCSXDQAwTw2zM6Na2Ytllz3qCRanP4DDw=; b=G5/gVG2klEh7tRuvNEwu5GDAfHxjvhSgsWJdfqrv9RhQLOLvEloXbyvR5zV2u0BkgJOOI5ZUMX65b2eDMRyMeM03A0zPooCFkVyQbZGCroh4Kqlfslv3INwsvqL4+wJyxHnVNZKJmN7/pbfBr865tn8n4/m+zUQpuuVZmajUc4Y= ARC-Authentication-Results: i=1; mx.zoho.com; dkim=pass header.i=zohocorp.com; spf=pass smtp.mailfrom=samuel.cc@zohocorp.com; dmarc=pass header.from= header.from= DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1539755750; s=admin; d=zohocorp.com; i=samuel.cc@zohocorp.com; h=Date:From:To:Message-Id:In-Reply-To:Subject:MIME-Version:Content-Type; l=1301; bh=aSIwQPPp7EBCSXDQAwTw2zM6Na2Ytllz3qCRanP4DDw=; b=E5wOaO8m+qxWaeeWpVenzHHltoOrTTb03B7RgL+/Q5Lf9ONAl+lEArC550rJMRj+ lyweESyURp7tP3t2vh6Kd6slevUqDMky8UaeTUytOtpLPb19qkBMXPk+IuZ0tC3wfjz qNWFHdIAKA//QnxJwPpvi5ii90OSvrhlreYCtgNg= Received: from mail.zoho.com by mx.zohomail.com with SMTP id 1539755749729781.541140049112; Tue, 16 Oct 2018 22:55:49 -0700 (PDT) Date: Wed, 17 Oct 2018 11:25:49 +0530 From: samuel.cc@zohocorp.com To: "pgsql-admin" Message-Id: <1668098315f.ce80698430328.8615948431745549527@zohocorp.com> In-Reply-To: Subject: Slow client connection to postgresql server MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_96551_1796054111.1539755749727" X-Priority: Medium User-Agent: Zoho Mail X-Mailer: Zoho Mail List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_96551_1796054111.1539755749727 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi all, =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 We have a postgresql production server= accepting max 100 connections. We also have a pgbouncer running to serve 1= 000 clients in session mode. It takes 3 secs to establish connection to postgresql using psql in that ma= chine. What might be reason for this ? How can I debug and fix this.? ------=_Part_96551_1796054111.1539755749727 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: 7bit
Hi all,
       We have a postgresql production server accepting max 100 connections. We also have a pgbouncer running to serve 1000 clients in session mode.
It takes 3 secs to establish connection to postgresql using psql in that machine.
What might be reason for this ?
How can I debug and fix this.?




------=_Part_96551_1796054111.1539755749727--