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 1jIs31-0001nj-3S
	for psycopg@arkaria.postgresql.org; Mon, 30 Mar 2020 10:53:39 +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 1jIs2z-0006q6-QO
	for psycopg@arkaria.postgresql.org; Mon, 30 Mar 2020 10:53:37 +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 <daniele.varrazzo@gmail.com>)
	id 1jIs2z-0006pz-Io
	for psycopg@lists.postgresql.org; Mon, 30 Mar 2020 10:53:37 +0000
Received: from mail-lf1-x144.google.com ([2a00:1450:4864:20::144])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1jIs2x-0004aK-HJ
	for psycopg@postgresql.org; Mon, 30 Mar 2020 10:53:36 +0000
Received: by mail-lf1-x144.google.com with SMTP id s13so2590084lfb.9
        for <psycopg@postgresql.org>; Mon, 30 Mar 2020 03:53:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=NRza3aTTpCSTqwcjfX546adNW8AGR0ARuoSMS7ATu5A=;
        b=fEdrGRS07feHLnwuDnq+GQdlVbsnM+TiwJZBumeL8Ji4Etfbs7EZCGJF283cF8VxkB
         urfB9vKZoD+orTXGkBm78MKtxVBQU5Xed1xXvWAIFMc/gra4K7RprXp0Yo8KLNOIKBOH
         HgED0UVozzPZTL/1W59QUs43oHPTnKV86TMmSGZVfmr1wWYRvt+xLgKxankRhQzUzbF9
         BQWQLFCKGbhzVzR50jkahxqiiu30T30QDPSpPJcFhG2wiBiknvRHUu0E9MHnqiHEqKti
         sOeMe5FtlW+uYfxcwB87ybrywI33GSAgoWoKnpuRJg5pNjPgeEpG4qxJ8Ru5bjoD2azB
         eFiw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=NRza3aTTpCSTqwcjfX546adNW8AGR0ARuoSMS7ATu5A=;
        b=Vr4+Xrcn+M0bh97iKOwXSZwjHYOP4LWpWLoGTw9K/nw26szyhFv54Bm5JPoCABR7dH
         J26KiM7TyR2Gso8J/HHW8Kc/ILmN6XMDoyKkbJYv8GyI75orKjLGBXgmOgOny7/MUGgj
         mkwLDkZf26Bw/PHJPKxavUDBCHkbVlt4hZ+Z7qdylHd+D/qlW4PPP+FyfiZZtfmpN1Ks
         2LuHMndDt8AkrmLjYGEqf0RE6Jixr0GVgeT7L+YF1oiDUTGH0BRfeJL91NH1zLZ5Rej/
         j8mSuE+xM8PINKGCvc/INSF899mqHCkt8mTVU5ciOhuq522pM2I2Q0eu4NrNu+qhINZ2
         gRMg==
X-Gm-Message-State: AGi0Pua2BnkNjFS8sF/7OgfYtkpVlf2FAvm4DgFoAhaodWqc3AqO8p7l
	TjRF2r27+dEeYBfo82NnQeA1BPCmhGQyTZiFxZE=
X-Google-Smtp-Source: 
 APiQypKeK/+5GAkDYmyHWsRFcAcgle/quBiDA/8kg1mdlzF3CZ+o3u4OO/nxdjLVH7K4UvnjWzFXhqFvmeA4zA1GMRE=
X-Received: by 2002:ac2:5c5d:: with SMTP id s29mr7750603lfp.129.1585565613680;
 Mon, 30 Mar 2020 03:53:33 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+mi_8ZH-feQP0+k_j7_joygE=hMZCFnaNMv8Z1KCLKB9YLb0w@mail.gmail.com>
 <CAP50yQ_Mt=RtR0sXYoazJTuarphR1Kv8A6YTevCMiv+xZeD9=Q@mail.gmail.com>
In-Reply-To: 
 <CAP50yQ_Mt=RtR0sXYoazJTuarphR1Kv8A6YTevCMiv+xZeD9=Q@mail.gmail.com>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Mon, 30 Mar 2020 23:53:17 +1300
Message-ID: 
 <CA+mi_8ahcjsKpRWgdROunrJBB3=aGgj0HYZoaTOkf4uJcKgCrw@mail.gmail.com>
Subject: Re: psycopg3: a first report
To: Stefan Knecht <knecht.stefan@gmail.com>
Cc: psycopg@postgresql.org
Content-Type: text/plain; charset="UTF-8"
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 Mon, 30 Mar 2020 at 17:27, Stefan Knecht <knecht.stefan@gmail.com> wrote:

> I would love to see a fundamental implementation of timeouts at the connection level, regardless of activity

By the way, did you try playing with the libpq socket options, such as
tcp_user_timeout?


-- Daniele