Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDDPN-00040g-Es for pgsql-docs@arkaria.postgresql.org; Tue, 01 Sep 2020 21:01:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kDDPM-0006kZ-AL for pgsql-docs@arkaria.postgresql.org; Tue, 01 Sep 2020 21:01:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDDPM-0006kM-4l for pgsql-docs@lists.postgresql.org; Tue, 01 Sep 2020 21:01:36 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDDPK-0003ne-0O for pgsql-docs@lists.postgresql.org; Tue, 01 Sep 2020 21:01:35 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kDDPH-0003dC-M7; Tue, 01 Sep 2020 17:01:31 -0400 Date: Tue, 1 Sep 2020 17:01:31 -0400 From: Bruce Momjian To: Pavel Luzanov Cc: "David G. Johnston" , pluzanov@postgrespro.ru, pgsql-docs@lists.postgresql.org Subject: Re: max_wal_size Message-ID: <20200901210131.GB13613@momjian.us> References: <159057129673.7025.17016799863173731176@wrigleys.postgresql.org> <92491c6d07a3216ef2caee8ef55c02b5@postgrespro.ru> <8aac88e2a22cd84e50ee1a2bcf3da9b7@postgrespro.ru> <20200602193547.GA26240@momjian.us> <26906a54-d7cb-2f8e-eed7-e31660024694@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <26906a54-d7cb-2f8e-eed7-e31660024694@postgrespro.ru> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Jun 2, 2020 at 11:42:01PM +0300, Pavel Luzanov wrote: > Hello, > > On 02.06.2020 22:35, Bruce Momjian wrote: > > On Thu, May 28, 2020 at 12:21:14PM +0300, p.luzanov@postgrespro.ru wrote: > > > WAL |-----------|-----+-----|-----+-----|-----+-----> > > > > > > a b c > > > CP +-----+ +-----+ +-----+ > > > b e b e b e > > > > > > Checkpointer process for point A starts at a(b) and ends at a(e). > > > At the end of the work, CP makes a WAL record(plus symbol on WAL line). > > > > > > Back to the max_wal_size description: > > > "Maximum size to let the WAL grow to between automatic WAL checkpoints." > > > > > > As I understand now, this is true when we talk about the checkpoint as a > > > process. > > > "Maximum size to let the WAL grow to between a(b) and b(e), between b(b) and c > > > (e), etc". > > What if we say: > > > > "Maximum size to let the WAL grow during automatic WAL checkpoints." > > > > That highlights the "process" part. > > > Really, "during" is associated with the process, while "between" with > points. > > If there is no objection, simple patch attached. Applied to all supported versions, thanks. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee