{"Entry":{"collection":"guc","key":"tcp_keepalives_idle","name":"tcp_keepalives_idle","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Connections and Authentication / TCP Settings","category_zh":"","changed_in":["14","16","18"],"changes":[{"documentation_changed":false,"fields":{},"from":"8.0","status":"added","to":"8.1"},{"documentation_changed":true,"fields":{},"from":"8.1","status":"changed","to":"8.2"},{"documentation_changed":true,"fields":{},"from":"8.4","status":"changed","to":"9.0"},{"documentation_changed":true,"fields":{},"from":"9.1","status":"changed","to":"9.2"},{"documentation_changed":true,"fields":{},"from":"9.3","status":"changed","to":"9.4"},{"documentation_changed":true,"fields":{},"from":"9.6","status":"changed","to":"10"},{"documentation_changed":true,"fields":{},"from":"11","status":"changed","to":"12"},{"documentation_changed":false,"fields":{"category":{"from":"Client Connection Defaults / Other Defaults","to":"Connections and Authentication / Connection Settings"}},"from":"13","status":"changed","to":"14"},{"documentation_changed":true,"fields":{"category":{"from":"Connections and Authentication / Connection Settings","to":"Connections and Authentication / TCP Settings"}},"from":"15","status":"changed","to":"16"},{"documentation_changed":false,"fields":{"extra_desc":{"from":"A value of 0 uses the system default.","to":"0 means use the system default."}},"from":"17","status":"changed","to":"18"}],"content_hash":"0a385daebc9f643406c22ca9183697f94527857d9d3f7ebdcf429279b422f324","context":"","default_changed_in":[],"default_history":[{"from":"9.0","to":"19","value":"0 s"}],"derived_content_hash":"1d03df32c3593aab9be1e2b618bf6d10e5839a99d6177a971aa16285eae04a77","editorial":{"advice":{"olap":"Long analytical connections need keepalive timing shorter than intervening network idle expiry but not so aggressive that transient loss aborts healthy jobs.","oltp":"Choose tcp_keepalives_idle with the other keepalive controls so total failure-detection time fits load-balancer, failover, and retry budgets. Confirm the operating system implements the requested socket option.","small":"Use operating-system defaults unless a measured network failure mode requires an override; tune the complete idle/interval/count tuple, not tcp_keepalives_idle alone."},"mechanism":["tcp_keepalives_idle defines the interval between issuing TCP keepalives. 0 means use the system default. It determines how long an otherwise idle TCP connection waits before the first keepalive probe; zero selects the operating-system default.","tcp_keepalives_idle is a USER-context setting. An authorized role can change it for a session, while ALTER ROLE or ALTER DATABASE can establish a default for future sessions.","The effective failure window is derived from tcp_keepalives_idle, tcp_keepalives_interval, and tcp_keepalives_count, subject to operating-system support and any shorter network-device timeout."],"pitfalls":["Changing tcp_keepalives_idle in one session and assuming role defaults, database defaults, or other pooled sessions changed with it.","Tuning one keepalive component without calculating the full idle-plus-retransmit failure window.","Assuming PostgreSQL's requested value overrides unsupported platforms or a shorter firewall and load-balancer idle policy.","Choosing a value longer than the network device's idle timeout and never getting a useful probe first."],"references":[{"title":"PostgreSQL 19 Beta 4: tcp_keepalives_idle","url":"https://www.postgresql.org/docs/19/runtime-config-connection.html#GUC-TCP-KEEPALIVES-IDLE"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["tcp_keepalives_interval","tcp_keepalives_count","tcp_user_timeout","client_connection_check_interval","authentication_timeout"],"summary":"tcp_keepalives_idle is the PostgreSQL setting that defines the interval between issuing TCP keepalives."},"enumvals":[],"first_version":"8.1","group":"Connections and Authentication","group_slug":"connection","imported_at":"2026-09-27T17:57:32.139934+08:00","intro_commit":{},"key":"tcp_keepalives_idle","last_version":"20","max_val":"","min_val":"","name":"tcp_keepalives_idle","position":407,"present_in":["8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"english-manuals:96e2de3b09734674c3827a734a4547788a5cef8fc8c77c8709984abe3906f1f1","receipt_sha256":"22a9ac9dbd902a0d6606ad54c7c96b0118a88c619565668776b2dc872d2dd9cb","repair":"wiki-repair-20261023"},"short_desc":"Specifies the amount of time with no network activity after which the operating system should send a TCP keepalive message to the client.","short_desc_zh":"","source_rev":"wiki-repair-20261023:8cd2eba345331bf8a2c95711d60298edc87fe931a88d281abd0f61ad4d6c1883","unit":"","vartype":"integer"}},"Definition":{"Collection":"guc","Key":"tcp_keepalives_idle","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"tcp_keepalives_idle","SourceRevision":"wiki-repair-20261023:8cd2eba345331bf8a2c95711d60298edc87fe931a88d281abd0f61ad4d6c1883","Facts":{"boot_val":"0","category":"Connections and Authentication / TCP Settings","context":"user","description":"Specifies the amount of time with no network activity after which the operating system should send a TCP keepalive message to the client. If this value is specified without units, it is taken as seconds. A value of 0 (the default) selects the operating system's default. On Windows, setting a value of 0 will set this parameter to 2 hours, since Windows does not provide a way to read the system default value. This parameter is supported only on systems that support TCP_KEEPIDLE or an equivalent socket option, and on Windows; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is ignored and always reads as zero.","description_zh":"指定在多久没有网络活动后，操作系统应向客户端发送 TCP keepalive 消息。如果指定值时没有单位，则以秒为单位。值 0（默认值）表示选择操作系统默认值。在 Windows 上，将该值设为 0 会把此参数设为 2 小时，因为 Windows 不提供读取系统默认值的方法。这个参数只有在支持 TCP_KEEPIDLE 或等效套接字选项的系统以及 Windows 上才可用；在其他系统上，它必须为零。在通过 Unix 域套接字连接的会话中，这个参数会被忽略，并始终读作零。","description_zh_html":"\u003cp\u003e\n        指定在多久没有网络活动后，操作系统应向客户端发送 TCP keepalive 消息。如果指定值时没有单位，则以秒为单位。值 \u003ccode class=\"literal\"\u003e0\u003c/code\u003e（默认值）表示选择操作系统默认值。在 Windows 上，将该值设为 \u003ccode class=\"literal\"\u003e0\u003c/code\u003e 会把此参数设为 2 小时，因为 Windows 不提供读取系统默认值的方法。这个参数只有在支持 \u003ccode class=\"symbol\"\u003eTCP_KEEPIDLE\u003c/code\u003e 或等效套接字选项的系统以及 Windows 上才可用；在其他系统上，它必须为零。在通过 Unix 域套接字连接的会话中，这个参数会被忽略，并始终读作零。\n       \u003c/p\u003e","doc":{"anchor":"GUC-TCP-KEEPALIVES-IDLE","file":"runtime-config-connection.html","lang":"en","sha256":"567ba928f3e4c4783f548dc8a54f1e748f02bbe163924605f2132eb5b0da440d","slug":"18"},"documented":true,"enumvals":null,"extra_desc":"0 means use the system default.","lang":"en","max_val":"2147483647","metadata_version":"18","min_val":"0","name":"tcp_keepalives_idle","short_desc":"Time between issuing TCP keepalives.","source":"pg-settings-source-snapshot","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-connection.html","sha256":"f4e5e4debc927cfa154bbdd71f3bf2eda8130ac3acace1109fe7d45ef2a3456b"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"unit":"s","vartype":"integer","zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"GUC-TCP-KEEPALIVES-IDLE","file":"runtime-config-connection.html","lang":"en","sha256":"567ba928f3e4c4783f548dc8a54f1e748f02bbe163924605f2132eb5b0da440d","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"tcp_keepalives_idle","SourceDatabase":"center","Version":"18","Locale":"en","Title":"tcp_keepalives_idle","Summary":"Specifies the amount of time with no network activity after which the operating system should send a TCP keepalive message to the client. If this value is specified without units, it is taken as seconds. A value of 0 (the default) selects the operating system's default. On Windows, setting a value of 0 will set this parameter to 2 hours, since Windows does not provide a way to read the system default value. This parameter is supported only on systems that support TCP_KEEPIDLE or an equivalent socket option, and on Windows; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is ignored and always reads as zero.","BodyHTML":"\u003cp\u003eSpecifies the amount of time with no network activity after which the operating system should send a TCP keepalive message to the client. If this value is specified without units, it is taken as seconds. A value of 0 (the default) selects the operating system\u0026#39;s default. On Windows, setting a value of 0 will set this parameter to 2 hours, since Windows does not provide a way to read the system default value. This parameter is supported only on systems that support TCP_KEEPIDLE or an equivalent socket option, and on Windows; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is ignored and always reads as zero.\u003c/p\u003e","SourceRevision":"wiki-repair-20261023:8cd2eba345331bf8a2c95711d60298edc87fe931a88d281abd0f61ad4d6c1883","ContentHash":"293d8d1a40f125039f71cdf55071c72449b9cc60d2ae6f3dedf6c9bd47cd4eb7","Payload":{"description":"Specifies the amount of time with no network activity after which the operating system should send a TCP keepalive message to the client. If this value is specified without units, it is taken as seconds. A value of 0 (the default) selects the operating system's default. On Windows, setting a value of 0 will set this parameter to 2 hours, since Windows does not provide a way to read the system default value. This parameter is supported only on systems that support TCP_KEEPIDLE or an equivalent socket option, and on Windows; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is ignored and always reads as zero."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}