From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Add support TCP user timeout in libpq and the backend server |
Date: | 2019-04-06 06:43:35 |
Message-ID: | E1hCf39-0000wm-TJ@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Add support TCP user timeout in libpq and the backend server
Similarly to the set of parameters for keepalive, a connection parameter
for libpq is added as well as a backend GUC, called tcp_user_timeout.
Increasing the TCP user timeout is useful to allow a connection to
survive extended periods without end-to-end connection, and decreasing
it allows application to fail faster. By default, the parameter is 0,
which makes the connection use the system default, and follows a logic
close to the keepalive parameters in its handling. When connecting
through a Unix-socket domain, the parameters have no effect.
Author: Ryohei Nagaura
Reviewed-by: Fabien Coelho, Robert Haas, Kyotaro Horiguchi, Kirk
Jamison, Mikalai Keida, Takayuki Tsunakawa, Andrei Yahorau
Discussion: https://postgr.es/m/EDA4195584F5064680D8130B1CA91C45367328@G01JPEXMBYT04
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/249d64999615802752940e017ee5166e726bc7cd
Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 1 +
contrib/postgres_fdw/sql/postgres_fdw.sql | 1 +
doc/src/sgml/config.sgml | 25 +++++++++
doc/src/sgml/libpq.sgml | 14 +++++
src/backend/libpq/pqcomm.c | 73 ++++++++++++++++++++++++++
src/backend/utils/misc/guc.c | 31 +++++++++++
src/backend/utils/misc/postgresql.conf.sample | 4 +-
src/include/libpq/libpq-be.h | 6 ++-
src/include/utils/guc.h | 1 +
src/interfaces/libpq/fe-connect.c | 43 +++++++++++++++
src/interfaces/libpq/libpq-int.h | 1 +
11 files changed, 198 insertions(+), 2 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-04-06 19:09:23 | pgsql: Fix failures in validateForeignKeyConstraint's slow path. |
Previous Message | Tom Lane | 2019-04-05 23:21:08 | pgsql: Use Append rather than MergeAppend for scanning ordered partitio |