Re: zombie connections - Mailing list pgsql-hackers

From Robert Haas
Subject Re: zombie connections
Date
Msg-id CA+TgmoYM0sWWH4J1H0-cBsJfWyuzF53da3eFp_EDa53uOT=ZWA@mail.gmail.com
Whole thread Raw
In response to Re: zombie connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: zombie connections
List pgsql-hackers
On Fri, Apr 3, 2020 at 10:34 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> In general I think the threshold problem for a patch like this will be
> "how do you keep the added overhead down".  As Robert noted upthread,
> timeout.c is quite a bit shy of being able to handle timeouts that
> persist across statements.  I don't think that there's any fundamental
> reason it can't be improved, but it will need improvements.

Why do we need that? If we're not executing a statement, we're
probably trying to read() from the socket, and we'll notice if that
returns 0 or -1. So it seems like we only need periodic checks while
there's a statement  in progress.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: adding partitioned tables to publications
Next
From: Tom Lane
Date:
Subject: Re: adding partitioned tables to publications