Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1jIpAG-0007cE-8h
	for psycopg@arkaria.postgresql.org; Mon, 30 Mar 2020 07:48:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1jIpAE-0000yK-Ul
	for psycopg@arkaria.postgresql.org; Mon, 30 Mar 2020 07:48:54 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jIpAE-0000yD-Eq
	for psycopg@lists.postgresql.org; Mon, 30 Mar 2020 07:48:54 +0000
Received: from campbell-lange.net ([178.79.140.51])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jIpAB-0002wS-80
	for psycopg@postgresql.org; Mon, 30 Mar 2020 07:48:53 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=campbell-lange.net; s=it; h=In-Reply-To:Content-Type:MIME-Version:
	References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To:
	Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date:
	Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:
	List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive;
	 bh=xiTuaUVe/gFiZVDeBuc3xkWHtivudGPNTevQpxYIRlQ=; b=CQH4PkauEcRTrfE1/qcVje7cJ
	p2sKOW0pPIDDdZpXFl8QI6jt/q3NYTXOv0gJG0eMtTCRQWd1DHhVjP7OiAiXZ2r+lR6A2LjBQuTrR
	yPWYgWUnKNciH5unQidRX+h2YGhCZ5SLBtV88wvfNPDhYTVrLP+OcUkYhv/lhbUDu+mXc=;
Received: from 186.164.198.146.dyn.plus.net ([146.198.164.186]
 helo=rory-t450s)
	by campbell-lange.net with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rory@campbell-lange.net>)
	id 1jIpA9-0005w2-3x; Mon, 30 Mar 2020 07:48:49 +0000
Received: from rory by rory-t450s with local (Exim 4.92)
	(envelope-from <rory@rory-t450s>)
	id 1jIpAb-0007Zg-4p; Mon, 30 Mar 2020 08:49:17 +0100
Date: Mon, 30 Mar 2020 08:49:17 +0100
From: Rory Campbell-Lange <rory@campbell-lange.net>
To: Stefan Knecht <knecht.stefan@gmail.com>
Cc: Daniele Varrazzo <daniele.varrazzo@gmail.com>, psycopg@postgresql.org
Subject: Re: psycopg3: a first report
Message-ID: <20200330074917.GA28993@campbell-lange.net>
References: 
 <CA+mi_8ZH-feQP0+k_j7_joygE=hMZCFnaNMv8Z1KCLKB9YLb0w@mail.gmail.com>
 <CAP50yQ_Mt=RtR0sXYoazJTuarphR1Kv8A6YTevCMiv+xZeD9=Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAP50yQ_Mt=RtR0sXYoazJTuarphR1Kv8A6YTevCMiv+xZeD9=Q@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

On 30/03/20, Stefan Knecht (knecht.stefan@gmail.com) wrote:
> If I may, one thing that has been a constant troublemaker for us - running
> primarily on AWS - is timeouts. 

If the issue is disappearing hosts or general connectivity problems,
isn't that problem best dealt with by pg_bouncer?

https://www.pgbouncer.org/config.html#connection-sanity-checks-timeouts

Specifically you may wish to refer to server_connect_timeout.

Rory