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 1jdt7M-00079F-BD for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2020 10:17:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jdt7L-0003fR-A9 for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2020 10:16:59 +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 1jdt7L-0003et-4L for pgsql-docs@lists.postgresql.org; Wed, 27 May 2020 10:16:59 +0000 Received: from mail.i-mark.de ([188.138.104.222]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdt7G-0006Uf-8U for pgsql-docs@lists.postgresql.org; Wed, 27 May 2020 10:16:58 +0000 Received: from [192.168.178.20] (unknown [185.38.49.17]) by mail.i-mark.de (Postfix) with ESMTPSA id 165DC1584247 for ; Wed, 27 May 2020 12:16:48 +0200 (CEST) Authentication-Results: loft7616.startdedicated.de; spf=pass (sender IP is 185.38.49.17) smtp.mailfrom=andreas@a-kretschmer.de smtp.helo=[192.168.178.20] Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated) Subject: Re: max_wal_size To: pgsql-docs@lists.postgresql.org References: <7020bbeb-cde5-b203-9803-2facd964688b@postgrespro.ru> From: Andreas Kretschmer Message-ID: <5d9bf1bd-d322-ba24-ce89-fa6029eb6615@a-kretschmer.de> Date: Wed, 27 May 2020 12:16:49 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 In-Reply-To: <7020bbeb-cde5-b203-9803-2facd964688b@postgrespro.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Am 27.05.20 um 12:11 schrieb Pavel Luzanov: > Hello, > > About parameter max_wal_size the documentation > > says: "Maximum size to let the WAL grow to between automatic WAL > checkpoints." > Is it correct? > > The size between automatic WAL checkpoints or the size of all WAL > files in the pg_wal directory? size between checkpoints, size of all wal's can be higher, see wal_keep_segments. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com