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 1jdtGS-0007Xh-E1 for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2020 10:26:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jdtGQ-0006dv-4Q for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2020 10:26:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdtGP-0006do-S4 for pgsql-docs@lists.postgresql.org; Wed, 27 May 2020 10:26:21 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jdtGJ-0001dK-26 for pgsql-docs@lists.postgresql.org; Wed, 27 May 2020 10:26:21 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 6BE3C21C6AA4; Wed, 27 May 2020 13:26:14 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-99 required=4 WHITELISTED tests=[] autolearn=unavailable Received: from [10.0.1.12] (unknown [188.123.231.178]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 38E7521C2760; Wed, 27 May 2020 13:26:14 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1590575174; bh=JQ6hURtKf3JCyAgKvXy4Wnt4I0euVTZ4bT3ELYOxBMk=; h=Subject:To:References:From:Date:In-Reply-To; b=hKN1yy/7NW8U6OTSZvkE81QpXEy5ycAnETxHqHxlOlzQUiBxyp/1U2/xsrBbf+YVs BexB7C/XczvDoqF55xtPdcC86ybidg2PW5NF8hWC/O92gNFFV79/Swj7LfbeuekcsR 4SZqPjt64BrNKfho7/WJDPQ2ExrKxcOd14MHBW1Y= Subject: Re: max_wal_size To: Andreas Kretschmer , pgsql-docs@lists.postgresql.org References: <7020bbeb-cde5-b203-9803-2facd964688b@postgrespro.ru> <5d9bf1bd-d322-ba24-ce89-fa6029eb6615@a-kretschmer.de> From: Pavel Luzanov Message-ID: <97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru> Date: Wed, 27 May 2020 13:26:13 +0300 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: <5d9bf1bd-d322-ba24-ce89-fa6029eb6615@a-kretschmer.de> Content-Type: multipart/alternative; boundary="------------A684D0EE17F2593BC86A102D" Content-Language: ru-RU List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------A684D0EE17F2593BC86A102D Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Andreas, > size between checkpoints, size of all wal's can be higher, see > wal_keep_segments. Hm, I also thought, but after looking at the source , it seems like this is a restriction on all files in pg_wal. ----- Pavel Luzanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------A684D0EE17F2593BC86A102D Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Andreas,

size between checkpoints, size of all wal's can be higher, see wal_keep_segments.

Hm, I also thought, but after looking at the source, it seems like this is a restriction on all files in pg_wal.

-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--------------A684D0EE17F2593BC86A102D--