From: | "Jaime Casanova" <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: keepalives_* parameters usefullness |
Date: | 2011-07-04 19:00:40 |
Message-ID: | 87sjqlj2g7.fsf@casanova1.SEINGALT |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On Mon, Jul 4, 2011 at 9:42 AM, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
>
>> i even used getsockopt() to ensure TCP_KEEPIDLE was being setted and
>> tried to set it myself with setsockopt() with the same results.
>
> There's a list of preconditions as to when these settings take effect,
> otherwise they are a no-op.
>
do we know what those preconditions are? TFM just says:
"""
keepalives_idle
Controls the number of seconds of inactivity after which TCP should send
a keepalive message to the server. A value of zero uses the system
default. This parameter is ignored for connections made via a
Unix-domain socket, or if keepalives are disabled. It is only supported
on systems where the TCP_KEEPIDLE or TCP_KEEPALIVE socket option is
available, and on Windows; on other systems, it has no effect.
"""
which made me think that on my debian system it should work so maybe we
want to document those preconditions, even a statement indicating that
other factors can prevent this working as expected would be good
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL
Soporte 24x7, desarrollo, capacitación y servicios
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2011-07-04 19:01:16 | Re: [HACKERS] BUG #6083: psql script line numbers incorrectly count \copy data |
Previous Message | Alvaro Herrera | 2011-07-04 18:38:26 | pgsql: Move Trigger and TriggerDesc structs out of rel.h into a new rel |