Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iRqRC-00033E-Ms for pgsql-docs@arkaria.postgresql.org; Tue, 05 Nov 2019 04:27:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iRqRB-0006dk-7l for pgsql-docs@arkaria.postgresql.org; Tue, 05 Nov 2019 04:27:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iRqRA-0006dd-TM for pgsql-docs@lists.postgresql.org; Tue, 05 Nov 2019 04:27:25 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iRqR8-0006gd-Fu for pgsql-docs@lists.postgresql.org; Tue, 05 Nov 2019 04:27:23 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 19EE3380; Mon, 4 Nov 2019 23:27:21 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 04 Nov 2019 23:27:21 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=kPtxMNXFbpNdNFwv7mTug25QlTG EpDnc2G9Fh25TZoY=; b=iSk39eUB2KtKoMWD/eY7Hf/dOSLPkBbb/SsMqYRQPNR 00APJM8Vh+QAlgVVUnJXq10TVmk2sazmU/nkpCHLYDek3q6xgRgyMwMEpilQ8US5 /oFcT5/YOn03ya822vIYR60vA6JebbaRPLM5HqlT+Lw2FL/TFQr7J8/I608WGW/B 6tBbuQjnj/UGzWxXEjUA3aLwKwXdO8TDsL2KkQG1OA7rX1xmlEHJ1II3XU7393s0 WTREQFcXY/IS7F0EZ120aXDbNygUw/GKL4OIq9em0lAOE/OI+iC1N7yn2CfkLAl/ ktufkWu3/QHMHohnfGSx+fhoX8fKj4TS+kqV0sLmxfw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=kPtxMN XFbpNdNFwv7mTug25QlTGEpDnc2G9Fh25TZoY=; b=Kvbv0TpZj5c++Y7ogJX+am l0rW0YcDSUPJMEtLooslfPwVcbkkYFZ2lDnRenm+GzsOwp1rn1g/B6jP0jtCuCVs eNch41rM9URt4lAnHUR9uBu2bLqa9xj3l7Na3mFo6OJLV7NrDEE72ZqQJNYhTnom VXg0BW9XHJgfzj+PLNDWR3jFFTf1ekeTd+9cVNstlBo70njiM3X3vv6Lpp10DxsI uJVkop+7oOtpmoBXMYGCwJ34YQI/InyWQFSl6kDTG3jFV6DV/POqAkDAgj/4ECue 6TqZFPZxndF4DSM9oUMKcSF3/lLs423kojFcrWhlbPjHIBslRS2QbV+uV9erUsIA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedruddugedgjeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepuddukedrvdeguddrvdehtddrudekvdenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fab6.ap.nuro.jp [118.241.250.182]) by mail.messagingengine.com (Postfix) with ESMTPA id E388580059; Mon, 4 Nov 2019 23:27:18 -0500 (EST) Date: Tue, 5 Nov 2019 13:27:16 +0900 From: Michael Paquier To: Bruce Momjian Cc: d.aumueller@proventa.de, pgsql-docs@lists.postgresql.org Subject: Re: wal_sender_timeout / wal_receiver_timeout - seconds or milliseconds? Message-ID: <20191105042716.GH16867@paquier.xyz> References: <157192240500.1043.7917781375772404449@wrigleys.postgresql.org> <20191105025234.GC12780@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="sl5MdczEF/OU2Miu" Content-Disposition: inline In-Reply-To: <20191105025234.GC12780@momjian.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --sl5MdczEF/OU2Miu Content-Type: multipart/mixed; boundary="it/zdz3K1bH9Y8/E" Content-Disposition: inline --it/zdz3K1bH9Y8/E Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Nov 04, 2019 at 09:52:34PM -0500, Bruce Momjian wrote: > The default _value_ is 60 seconds, and we use the 's' to specify > seconds. What the comment is saying is that if you _don't_ specify any > units, the integer is in milliseconds. I am not sure how to improve > that. I do have a suggestion as per the attached, say: +#wal_sender_timeout = 60s # in milliseconds if no unit specified; + # 0 disables -- Michael --it/zdz3K1bH9Y8/E Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="pgconf-units.patch" Content-Transfer-Encoding: quoted-printable diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/ut= ils/misc/postgresql.conf.sample index 0fc23e3a61..eea017e840 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -286,7 +286,8 @@ #max_wal_senders =3D 10 # max number of walsender processes # (change requires restart) #wal_keep_segments =3D 0 # in logfile segments; 0 disables -#wal_sender_timeout =3D 60s # in milliseconds; 0 disables +#wal_sender_timeout =3D 60s # in milliseconds if no unit specified; + # 0 disables =20 #max_replication_slots =3D 10 # max number of replication slots # (change requires restart) @@ -326,7 +327,8 @@ # query conflicts #wal_receiver_timeout =3D 60s # time that receiver waits for # communication from master - # in milliseconds; 0 disables + # in milliseconds if no unit specified; + # 0 disables #wal_retrieve_retry_interval =3D 5s # time to wait before retrying to # retrieve WAL after a failed attempt #recovery_min_apply_delay =3D 0 # minimum delay for applying changes duri= ng recovery --it/zdz3K1bH9Y8/E-- --sl5MdczEF/OU2Miu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3A+iQACgkQnvQgOdby QH3dOA/9GOz2yMmlZgaix15vRmL1bMuQcSwRJYeTdAiC+XY749mCn93OUHjcijlC 1bTh4aTlI/19V476ocI+LB/wUsNP1wuekWj9exQcOpXOsSsMPBEV1AKhOTKAMcbW gCYp5o5U4o9i2pWlFDIHzTuvV2DBSxCsV5ejMR3DvnpWk6yRXs7CczBkBvkhSeNe NV1kj8zVUFJfXhaCx16INl4/+LW51Flv8w8ytWn0W6lQMzHMADlRcSEPZQvjV5x1 Eu1FH9XcTdJ+vJpyP9NMuT05dcvsn13NWDlJW9XR6TyCjvWwW7CW/UDDEZxVf6nw L4iuQWxBYEMUtx5ApFtRUw537FfxMWVhVRyt3G8wTAgHEa51MNi539Y3UuzVDT/H nzJcdU52YtonkgGSJiTetNsZhcqXfFsg6v2i/vMAwJCd/UAnI2m61ieNm7wr2/dl TibZB3QKFyvGYndRmIbZkBw8YZ5sZgJGJnI8DSZplsxBpsW4Is/dBf5bEmAKqjHj PHKlKvznqzYSEL0psXVFNYm992fxnQQp40UAdJDfdq3Hnae3eTmDQsU//eKG71V4 NP1jWBcor2xInRuCruK8CMavuGCHTtc0ZXAHFtUSNeL2a782OhW9pwpREbgONuFp ks3t4K/LqRk4yhmx9mStEgklz+cgXMWiBtnV76QsEwALPiQtQL8= =F7ye -----END PGP SIGNATURE----- --sl5MdczEF/OU2Miu--