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 1hAwpX-0006rB-C3 for pgsql-docs@arkaria.postgresql.org; Mon, 01 Apr 2019 13:18:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hAwpV-0004UD-9C for pgsql-docs@arkaria.postgresql.org; Mon, 01 Apr 2019 13:18:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAwpU-0004TU-BT for pgsql-docs@lists.postgresql.org; Mon, 01 Apr 2019 13:18:25 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAwpM-0004Z0-Q0 for pgsql-docs@lists.postgresql.org; Mon, 01 Apr 2019 13:18:23 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id B4F0021EF1; Mon, 1 Apr 2019 09:18:14 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 01 Apr 2019 09:18:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=dhf7f2MWC5wJcqnJehfy9fyGmkG 6MC3bBJ9lPjCN2w0=; b=gsPHXaanc6v4fswylzS4x9oj9a+pFV37iUA/sV+Ru+Z L+QyQmeIVaq6BEQ4ONx4jjwy+HBXpK1YWcyrQImW8KAkK6gpKRD46Itsa1hqkEQL xJak+PmWWy4JSU3TIHvotzJKDDDM7xvViCb2z2pmsnISx6nwQpLmDqRe9N7rEcPQ X7cNEUY3mbp6hPe4EIOrRRZMlREFpPC3aa2nwiTPx1rfsAi8Pav2VFqJx1rnTlQO WBGiQwRXYkbnBXlhgFfGmgpNGk5OaA0pyoo30vjnPcrVGKjkr70d/o2g84juaOJm po5yQ7jos1VorPpxMmMpbXbm6+ElhaxPl+xnoPHmHcg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=fm2; bh=dhf7f2 MWC5wJcqnJehfy9fyGmkG6MC3bBJ9lPjCN2w0=; b=p+JjIWtacc2eXDqYVEk6yt AWRtUCAHSdjYByvRJkztbaiKM3k+0e4jMGqpD0paZ6nGESRCcgQW3kI/RxBB9k1j pfaSU4isrbCTx94g5Q/Uuv8w7TeDZlwKBHCDnQtgWr+ibOdTZRFuAOXodE2z3vaw XMbTlx7A9EUICLpgv5SpKEGAsc2D1IAbHEx7NwxQJw+12RlLz8l0vcQdYXWX+dfK CCNz1fmv4IPtOM9Qi92Cu/Dp/VjDBnaSaGppw2IEtwJcBuJ8puhsdjYG8I5Zaeb3 W5o0dRo8BsUfRSxl+ATFGX1Y9a4iRb/1bzwrP9173QUeWNQKekxGuWTk5xJkaL/A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrleeggdeiudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduuddurddutd dvrddukedtrddukeehnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehp rghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id CE0951030F; Mon, 1 Apr 2019 09:18:12 -0400 (EDT) Date: Mon, 1 Apr 2019 22:18:09 +0900 From: Michael Paquier To: chris+postgresql@qwirx.com, pgsql-docs@lists.postgresql.org Subject: Re: bgwriter_lru_multiplier maximum value Message-ID: <20190401131809.GD16093@paquier.xyz> References: <155411443331.724.3765587776420552242@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="OROCMA9jn6tkzFBc" Content-Disposition: inline In-Reply-To: <155411443331.724.3765587776420552242@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --OROCMA9jn6tkzFBc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Apr 01, 2019 at 10:27:13AM +0000, PG Doc comments form wrote: > The server has an undocumented maximum value of 10 for > bgwriter_lru_multiplier, and will fail to start if it's set higher than > this: >=20 > LOG: 20 is outside the valid range for parameter "bgwriter_lru_multiplie= r" > (0 .. 10) > FATAL: configuration file "/.../pgdata/postgresql.conf" contains errors I would suggest something like that: --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2050,7 +2050,8 @@ include_dir 'conf.d' Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. - The default is 2.0. + The default is 2.0. The value can range from 2.0 + to 10.0 This parameter can only be set in the postgresql.conf file or on the server command line. Any opinions from others? -- Michael --OROCMA9jn6tkzFBc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyiD5EACgkQnvQgOdby QH2zOw//b5nxsb71ikScWc9bS2uVBbrYzM4KZ5gyzwMW9n9U6uwLop4xxejvQ1qi nXRJnxYlqCZEe/5bW/rfyWCSmQdqxEGQmCJYt+KnMuD61lLRzxhOCI7lDJlSS0Sw oe7pL2YURfVE26We937QSXsWMd7MzGwWek4mIU6ETwynfUQVPHUv82Tc05hRULMG EOS4s/RN1i5ZL+WB4qZG8M+Up5YiOE9NXHsYUCigZHELI2YhlwbKU6dmwooi23Ea j2+94HsklzkaGn/gUd1KaWQLc1GjZFXRdJCdRqtMXgRMf7lkGc9OC3JbGm1erAF7 0gpyFZAFKSLd1YtMZgmSsm0PZKXdjpdVAefJJPiOROlvYVDHTRSEzTK21b0YE98D PzgC/sIU7+np3FxRaHd3QqNMxA+9hmEuwLsb63kTqfJKRQuegjLl59ko5gye2q9v 86NtxUonRTHz/tUyLQx3MkV7XJ5sFynVY3+9UMpgZNF72sXfyPv+JeDEq0X9wu8Z gsZf4VHJfEycZWijHhAcoKZffoZnHJ3CIB2UMdJKz4q53JcYO8qNc5sGp0vzS3pf ZkQVLxrVqJYPJX9YtWa2/8bcvVTAz2lqsG6ATp4qVmEkl3Hk/BV9M0OB3quRA+nY 3CVmGMwDdokOG7vM+EDRycPGB/5FpA7UNV1K1mLRjMxwYU/Ws3I= =KcFK -----END PGP SIGNATURE----- --OROCMA9jn6tkzFBc--