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 1r1Dt2-00A4ot-7H for pgsql-docs@arkaria.postgresql.org; Thu, 09 Nov 2023 22:52:32 +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 1r1Dt0-00HMao-Pj for pgsql-docs@arkaria.postgresql.org; Thu, 09 Nov 2023 22:52:30 +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 1r1Dt0-00HMag-IA for pgsql-docs@lists.postgresql.org; Thu, 09 Nov 2023 22:52:30 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r1Dsy-005dI6-0B for pgsql-docs@lists.postgresql.org; Thu, 09 Nov 2023 22:52:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:To:From:Date:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description; bh=UTBHSvngFzBzpVE36Mwjsp/h/RmhUQJt7r1KpvjOhIE=; b=y8ruI 10GsN7X4gPzwWWUtPCu/spc8u2pfzLhbB4ek1chaVm48XDAQ5bpP46dtU8DCWQ0476Xn4Hu3FCcFW qIgdvd8rFCNVt+hXoW+OPbCUjhrHs6LlXZkIuBWQEM9vWTHhdGQO3O/RFoHBDhvqhum7Xz0iUbwQ2 iYOmx0Wx7Md+W6IBx4bIQtqyMDs9NPX/X6g4LYixz+xgItcsd1GOfBrqJqOv5sMGbXHdkCPeHe9Tc yn0oT3J3QSyVnHbIyZL6edZhUJfwTO1zLClrKxxEO1R/qxsG2ujwQpCfaBylOCJLG21yg1SSmFAro PncfMQdNxTbnMqaG9vIOzsVgk9wQA==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1r1Dsw-002wCB-1g; Thu, 09 Nov 2023 17:52:26 -0500 Date: Thu, 9 Nov 2023 17:52:26 -0500 From: Bruce Momjian To: evan.macbeth@crunchydata.com, pgsql-docs@lists.postgresql.org Subject: Re: WAL Configuration Grammar Fix Message-ID: References: <155208475619.1380.12815553062985622271@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="J2x5vvS0aJHmeCPW" Content-Disposition: inline In-Reply-To: <155208475619.1380.12815553062985622271@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --J2x5vvS0aJHmeCPW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Mar 8, 2019 at 10:39:16PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/wal-configuration.html > Description: > > On the WAL Configuration page - > https://www.postgresql.org/docs/current/wal-configuration.html > It reads: "On Linux and POSIX platforms checkpoint_flush_after allows to > force the OS that pages written by the checkpoint should be flushed to disk > after a configurable number of bytes." > > I believe a "you" is missing. I also suggest a more clear sentence > construction might be: > "On Linux and POSIX platforms you can use checkpoint_flush_after to set a > configurable number of bytes after which the OS will be forced to flush to > disk the pages written by the checkpoint." This patch is 4.5 years old, but still valid. Fixed with the attached patch applied to master. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. --J2x5vvS0aJHmeCPW Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="master.diff" diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml index 4aad0e1a07..184404c6c5 100644 --- a/doc/src/sgml/wal.sgml +++ b/doc/src/sgml/wal.sgml @@ -602,7 +602,7 @@ On Linux and POSIX platforms - allows to force the OS that pages written by the checkpoint should be + allows you to force OS pages written by the checkpoint to be flushed to disk after a configurable number of bytes. Otherwise, these pages may be kept in the OS's page cache, inducing a stall when fsync is issued at the end of a checkpoint. This setting will --J2x5vvS0aJHmeCPW--