IronPort-PHdr: A9a23:/l1AvBTS+kv8boXuKQbqLWOKrtpso7vLVj580XJvo75Nc6H2+ZPkM
 QSf4Ph2l1bGUM3d7O4MkOvZta3sGAliqZaMuXwPatpAAhkCj8hFkwkpGsXQD0r9IbbjZDA7G
 8IXUlhj8jm7PEFZFdy4aUfVpyi57CUZHVP0Mg8mTtk=
IronPort-Data: A9a23:bMiDQKNaGDMhh8LvrR2ll8FynXyQoLVcMsEvi/4bfWQNrUon1WcHm
 mJND2/QPPjfMDb2Lo9yO9zkp0oG7cfdzN9jHnM5pCpnJ55oRWUpJjg4wmPYZX76whjrFRo/h
 ykmQoCcaphyFBcwnz/1WlTbhSEUOZqgG/ytU4YoBggrHVU+EHd72Uo68wIEqtcAbeaRUlvlV
 eza+6UzCHf9s9KjGjtJg04rgEoHUMXa4Fv0jHRnDRx4lAO2e00uMX4qDfrZw00U7WVjNrXSq
 +7rlNlV945ClvsnIovNfr3TKiXmTlNOVOSDoiI+ZkSsvvRNjioMw7g7aNkxUFpogmmzoIxOi
 /tilbXlHG/FPoWU8AgcexBcFyc7Nqpc9fqdZ3O+qseUiUbBdhMAwd03UxpwZtNeo70xWDoTn
 RAbAGhlghSrjOK/x7ajQ+9EjcU4J86tN4Qa0p1l5WCCVKZ+EMuTEs0m4/dz8ixsodJLPc3nP
 dUXaDxwbDT/SE1AbwJ/5JUWxbf02SaXnydjgEqavrMzpmHfyQ13+LzsK8bOPMSNXtlahEuDv
 2aA+H72aiz2L/SWzT6Dt3mrnOKKx2XwWZkZE/uz8fsCbECvKnI7DiMHS1vngtSAl3G3B+hgd
 3NX1AUOhP1nnKC0deXVUxq9qX+CmxcTXdtMDuE3gD1hLIKJvm514UBZE1Z8hMwaWNweHmdzj
 wDX9z/9LXk+7uPKGCv1GqK892vaBMQDEYMVicbopyMs593upunfZTqQE446S8ZZYjAJcAwcL
 hiDqCw4wr4Ul8NOjeOw/EvMhHSnoZ2hou8JCuf/ADrNAuBRPdHNi2mUBb7ztq4owGGxFQDpg
 ZT8s5LChN3i9LnU/MB3fM0DHauy+9GOOyDGjFhkEvEJrmrzoiD5INgKsWEleC+F1/ronxe0M
 Cc/XisMtPdu0IeCMcebnqroUZ1xlPi8fTgbfqmKNYomjmdNmP+vpXEyOhH4M5HFm0k3mqZ3I
 oaAbcupFh4n5VdPklKLqxMm+eZznEgWnDqLLbiilkjP+eTFPha9F+xaWGZim8hktstoVi2Pr
 YYGXyZLoj0CONDDjt7/qNNJdQxQfSFiX/gbaaV/L4a+H+avI0l5Y9e5/F/rU9YNc3h9/gsQw
 kyAZw==
IronPort-HdrOrdr: A9a23:0lSdJqk9JcU0aEpx4kKXXRwXpcPpDfOnimdD5ihNYBxZY6Wkfp
 +V8sjzhCWatN9OYh0dcIi7SdK9qADnhORICOgqTP+ftWzd2VdAQ7sSlLcKrweQeREWldQtnp
 uIEZIOcOEYZGIS5a2RjWnIcOrIq+P3lJxA8N2uqUuFOjsaDJ2IgT0JbzqzIwlTfk1rFJA5HJ
 2T6o5svDy7Y0kaacy9Gz0sQ/XDj8ejruOtXTc2QzocrCWehzKh77D3VzKC2A0Fbj9JybA+tU
 DYjg3C4Lm5uf3T8G6Q64aT1eUbpDLS8KoMOCW+sLlVFtwqsHfpWG1VYczMgNnympDt1L9lqq
 iPn/5qBbUP15qYRBDInfKq4Xik7N7rgEWSjmNxRhDY0IjErXsBerV8rJMcfR3D50U6utZglK
 pNwmKCrpJSSQjNhSLn+rHzJmZXf2eP0A8feNQo/ghieJpbbKUUoZ0U/UtTHptFFCXm6Jo/GO
 0rCM3H/v5ZfV6Tcnic5wBUsZWRd2V2Gg3DTlkJu8ST3TQTlHdlz1EAzMhamnsb7poyR5RN+u
 yBOKV1k7NFSNMQcMtGdZE8aNryDnaITQPHMWqUL1iiHKYbO2jVo5qy+7kx7PHCQu178HLzou
 WzbLp1jx9CR6u1M7zx4HRiyGG8fFmA
From: "James Pang (chaolpan)" <chaolpan@cisco.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: max_wal_size and wal_keep_size
Thread-Topic: max_wal_size and wal_keep_size
Thread-Index: Adi627j7Hj8XTkwPSs2+mWRgnozO9Q==
Date: Sun, 28 Aug 2022 12:45:44 +0000
Message-ID: 
 <PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?PCq1JJcVMBl+14VIWCziGeuUJnZ2MvgHOuNNTQnHcXRlq3i2o38hrl88v/qk?=
 =?us-ascii?Q?iiKHg98HFDEimC1/qnZRwUzXCsnAlkm4FjZ7BISPH0Sdx2U8WlRJNsL5OWwS?=
 =?us-ascii?Q?+CJkiO3bqxbVn5O1PZwTkpwkKmY2KgpxZYmLQnreDuqjCWwfv+P8Q7C0BSmK?=
 =?us-ascii?Q?rHvIV4+N0BQvJAexb5vuolnpfipkCJyO+OtibeQMT/7TU8z8dLT0abNQbPNb?=
 =?us-ascii?Q?GRF36zPhqmMqNOYV0yHyPu3+Ughc16GhPG88aX6YXyN7zYE/9jQm5TKklRoI?=
 =?us-ascii?Q?pXSsSGloP5SWIedwoYehUmnKIrEiNLRT2eK96rswQb3DhKOkvSR+2xCyXa/F?=
 =?us-ascii?Q?AXYqAnEqjVi65yywPXnO/4gbvffEouoyLTvIOH6mG014td6Sqy6R5Hg6Mu+W?=
 =?us-ascii?Q?zInPwdp+XPyD+43AOtRtlOPEVd5LNH0S6aJjSyB8xq4zDe+MVmFrwlkZDOHR?=
 =?us-ascii?Q?avlcg0JYt/P8cihfWyaFA0AqFYrnSUvUX1AtkEYPDYasYHQawKVgQUVZe5Ft?=
 =?us-ascii?Q?R94WxYetbonAjtvKzE0dPRpx7XtncZjaTlQH/Y2i9NkSnmDNwjTrZz35E20y?=
 =?us-ascii?Q?BEHjMDEcHjk45Amg/W3M0wL7RXcVAGt3wpC+OHsg3VCOZk54WY0SAMqtG+eC?=
 =?us-ascii?Q?zr/ivfIEtmLrBC11M456g91ByrxxQzhs2fHRTOZxekxFYqW7JYujgf6bBJzk?=
 =?us-ascii?Q?Z2vE4ITTO/9It+B45otksNZh5kj1rmrBuCuTvA2LEquh8aV3g4OseZezHUor?=
 =?us-ascii?Q?OPkdiI7stD5PRx62WvnwCJGqqYcWbcni5ENTvGDKLa5UXNoXicCPsglLdrFD?=
 =?us-ascii?Q?EJns39K8VeaI9ZGnqikmpZeAzOeLaNz9MOxRRia6wm97zMkMycTQZmytLDjD?=
 =?us-ascii?Q?tSxP0Mm8EMgZXNUGqAjCH20IAffi8HRSNI/3bedKr4D+L4PblL+7dzQiYiJM?=
 =?us-ascii?Q?4cYApjiwbMxI4Jdre9nplp5gXZvRdduu8z2BjgbcWgQG8yNJZjs8X1M44lG4?=
 =?us-ascii?Q?UszBjKuXIwg4cfyM5gMnNNgwGk0RgPxCrxUJr+TIujjjF+r52zIKK54b9wTy?=
 =?us-ascii?Q?ZkM28KHwEeU9h7Swis+gsYD4T+00/0b4gH8hNj7ccW+122LxH8J5IMcKtxfx?=
 =?us-ascii?Q?TRzUn+Z4a8DLoFHZTzGh3Tm6ul+kZdcIxtNvTOCLvNjOuGrgUCCLu3srXqlc?=
 =?us-ascii?Q?1R/Q+QSD/QtTLIAI8E4lmcmYV3zDPnJXT3cUKqibREBZViGwpfxyk65y9dYi?=
 =?us-ascii?Q?plwzPDvsui9dFoN5JkmgTu//698ziPcK4tPepw1OFcv4cJPmXlRMCli2baPp?=
 =?us-ascii?Q?FtlQqezzjMsxLWylqQSyuAgxhxWm7MM98P3f8Tv4QviQZ/P2BNvkEdg7T71U?=
 =?us-ascii?Q?PIpn02Z33aqYfINpv/axiJuQ0begikzt8R26nzesR1J0SKExHoQeQkATY3rd?=
 =?us-ascii?Q?jZ/R9BUa4iA3S0q7jECoo4W+E6XlK/j6hJJ1dAx2LHHX2Ztiz0VZouL6TSeH?=
 =?us-ascii?Q?AVM11SXoBT3X2j0li8v5lmEOeHzezf+r1nUKxHx2jmiJnw1iCJOteRfgmWwo?=
 =?us-ascii?Q?czV/XXsv8sETG81DF/Y=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH0PR11MB5191D04014D2F4F2FD2506BAD6779PH0PR11MB5191namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH0PR11MB5191.namprd11.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 78667858-2c78-4607-b747-08da88f33917
X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Aug 2022 12:45:44.2476
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 5ae1af62-9505-4097-a69a-c1553ef7840e
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 joWBSszEFvY6xTADjguMHtd5X0ck+CYLCW8a2ti1qodPkLrr8GDJmAKoYvNtQJRewzvgCW+9jhE350GcRhsHSA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM4PR11MB5568
X-OriginatorOrg: cisco.com
X-Outbound-SMTP-Client: 173.37.227.253, xfe-rcd-005.cisco.com
X-Outbound-Node: alln-core-2.cisco.com
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/PH0PR11MB5191D04014D2F4F2FD2506BAD6779%40PH0PR11MB5191.namprd11.prod.outlook.com>
Precedence: bulk

--_000_PH0PR11MB5191D04014D2F4F2FD2506BAD6779PH0PR11MB5191namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,
It's PGv13,  what's relationship between max_wal_size and wal_keep_size ?  =
For example, wal_keep_size=3D200GB(to keep enough wal on disk pg_wal) ,   w=
hat's best value for max_wal_size ?   we want to usage max_wal_size to cont=
rol checkpoint .

Thanks,

James

--_000_PH0PR11MB5191D04014D2F4F2FD2506BAD6779PH0PR11MB5191namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:DengXian;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:"\@DengXian";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:10.0pt">It&#8217;s PGv13,&nbsp;=
 what&#8217;s relationship between max_wal_size and wal_keep_size ? &nbsp;F=
or example, wal_keep_size=3D200GB(to keep enough wal on disk pg_wal) ,&nbsp=
; &nbsp;what&#8217;s best value for max_wal_size ?&nbsp;&nbsp; we want to u=
sage max_wal_size
 to control checkpoint .<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:10.0pt"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:10.0pt">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:10.0pt"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:10.0pt">James<o:p></o:p></p>
</div>
</body>
</html>

--_000_PH0PR11MB5191D04014D2F4F2FD2506BAD6779PH0PR11MB5191namp_--