From: samuel.cc@zohocorp.com
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Slow client connection to postgresql server
Date: Wed, 17 Oct 2018 11:25:49 +0530
Message-ID: <1668098315f.ce80698430328.8615948431745549527@zohocorp.com> (raw)
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.?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samuel.cc@zohocorp.com
Subject: Re: Slow client connection to postgresql server
In-Reply-To: <1668098315f.ce80698430328.8615948431745549527@zohocorp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox