Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZIAY-003LRN-LO for pgsql-docs@arkaria.postgresql.org; Sun, 11 Feb 2024 22:19:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rZIAX-005MCk-NR for pgsql-docs@arkaria.postgresql.org; Sun, 11 Feb 2024 22:19:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZIAX-005MCc-CO for pgsql-docs@lists.postgresql.org; Sun, 11 Feb 2024 22:19:25 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZIAV-006htF-9c for pgsql-docs@lists.postgresql.org; Sun, 11 Feb 2024 22:19:24 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id B4B9C2FE8698 for ; Sun, 11 Feb 2024 23:19:21 +0100 (CET) Received: from s981.loopia.se (unknown [172.22.191.6]) by s807.loopia.se (Postfix) with ESMTP id A3F762E2C6AA; Sun, 11 Feb 2024 23:19:21 +0100 (CET) Received: from s473.loopia.se (unknown [172.22.191.6]) by s981.loopia.se (Postfix) with ESMTP id A1CEB22B174F; Sun, 11 Feb 2024 23:19:21 +0100 (CET) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.21 X-Spam-Level: X-Spam-Status: No, score=-1.21 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, T_SCC_BODY_TEXT_LINE=-0.01] autolearn=disabled Authentication-Results: s473.loopia.se (amavisd-new); dkim=pass (2048-bit key) header.d=yesql.se Received: from s899.loopia.se ([172.22.191.6]) by s473.loopia.se (s473.loopia.se [172.22.190.13]) (amavisd-new, port 10024) with LMTP id IR_9SlPOXtCb; Sun, 11 Feb 2024 23:19:21 +0100 (CET) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 89.255.232.193 Received: from smtpclient.apple (customer-89-255-232-193.stosn.net [89.255.232.193]) (Authenticated sender: daniel@yesql.se) by s899.loopia.se (Postfix) with ESMTPSA id 1F5502C8BA5F; Sun, 11 Feb 2024 23:19:21 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yesql.se; s=loopiadkim1707475645; t=1707689961; bh=Xj4shuh3zkcj6uDxr7qmU1fUfJewEL8WpYttzv57/iA=; h=From:Subject:Date:References:To:In-Reply-To; b=bGuGs6i/HDY8yE3crkIscgeOhDJL98EntEdfqyXqiX2rrhtMLcxWTe6S8leHw1PyO t8Dm7VmZSY/p48B+qhfCeV9oFka661H2q6TGtijQLQv3FjCwzaUGlzJvN4cav9AHxI kExjGCBQb20DJMHyHZFW9rXgcXN4NUPG1SlL4ZRO4TC553umESYEbRUvMxRp+1+EJF ICFDXNtxVhvSWXbk1jO3E/VAeIqnGtS9FE9L+YOJHrVKaX8DHrVg6oxfvVCsO68wuT 0L/TZzOHuK/5cSH0B3gOW0cM9vzA350oLNHlkkmzuX6WEzNfemglFjEAWxLQvrUG0u mweiEVsnOf6tw== From: Daniel Gustafsson Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.4\)) Subject: Re: bgwriter_delay Date: Sun, 11 Feb 2024 23:19:20 +0100 References: <170752368082.3279718.1960370483154611839@wrigleys.postgresql.org> To: h@husseinnasser.com, pgsql-docs In-Reply-To: <170752368082.3279718.1960370483154611839@wrigleys.postgresql.org> Message-Id: X-Mailer: Apple Mail (2.3696.120.41.1.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 10 Feb 2024, at 01:08, PG Doc comments form = wrote: > Would be nice to add the limits to the doc, according to my pg15 = instance I > can't set bgwriter_delay more than 10000 ms. (I set it to 60 s and got = a > FATAL upon startup) We do print the valid range for other bgwriter GUCs so it doesn't seem = like an unreasonable idea. It might not help too many, but not printing it at = all clearly doesn't really help anyone. -- Daniel Gustafsson