From: Mendbayar Alzakhgui <mendbayar.alz@unitel.mn>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Postgre's replica holding huge amount of WAL
Thread-Topic: Postgre's replica holding huge amount of WAL
Thread-Index: AdvFYQoYn74D36bRRI+fvzDGNSsgDg==
Date: Thu, 15 May 2025 06:21:55 +0000
Message-ID: 
 <SEZPR01MB5748AB66F48B9A164728F4A0EA90A@SEZPR01MB5748.apcprd01.prod.exchangelabs.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?HcU9N87xvEu1OvCH/NTfo7SyUkQ2y9RaG6Qmom68OCnZP/x0O6WPLSAHyb/s?=
 =?us-ascii?Q?fdwmYxsKN3u9s9rvVzytYEaikpj8jnArq4iZDYHWn2sdxd5s6vCD1FCZ+A5G?=
 =?us-ascii?Q?4XiT3ywiKq9NZVnF1GEdZMgQKiTPsr1e9k3+4IqtRG59Y1+BHOWs7qF8CJad?=
 =?us-ascii?Q?xYmVqElUlBjwWNISLGpvem0IXjLvKIjjrNe79cAKpohRA+5LAPvLT8ZW6D4z?=
 =?us-ascii?Q?V51hgtpNGKI6lOZ3Wvw4+mtUlXKH3UkGbzV24DPOCsxwj5CSEqTTDZWbMKWu?=
 =?us-ascii?Q?+Pk8qT2ItKtVWYbdq6BV1H2tQbnsDb75W6J8cgDSnY6QMoi3skoCLhE20tA8?=
 =?us-ascii?Q?v7aWP3RJKJtyjZifsnVC4L/H2neetPeYXXxnPbaOgYl4RAnvGcLW/XndKJDi?=
 =?us-ascii?Q?+URKt1+uvL541Mg6y5AiVmAf8gbU5KY5BvAya1IYC9Pe/vmmPgYa4WU6N4Ft?=
 =?us-ascii?Q?sNvtLOwFEz5t+OE4IFCDnz0MLAfZJHzNyfBUDkgQws8xTKESePQUOOvz40Pa?=
 =?us-ascii?Q?2/MC2HGB+NYM1sdr7bv2B+iiCwJR0yF9hNaf3krTPI8SzW6ePM3aa6d+fhqD?=
 =?us-ascii?Q?NYxVLLvie0CeBYTokihTmLEPGI9NTGZJoyjsKxJGgGPt8W9CMJdX2RSiUquo?=
 =?us-ascii?Q?WnPT+4f2cDOu6lflLSL9ST7TpVgBFDjJx5pmJq6SBZFszmu4IRFIRYEjkOaS?=
 =?us-ascii?Q?/Y3jL7skQ633pQwpq9+efDn9LGZma5gQp8fnDlWGy1fRmPDLG34CXox/B2Z2?=
 =?us-ascii?Q?nPqfGamDRojVg2x54nGrY33lm2XeOmpldVDvAAd2xFeHvVjuE26NDbjH8Psd?=
 =?us-ascii?Q?pn27Wp0KMawhxy8fdZCKWGMwwsChPstlqPjlQMGV9JUBtGsxawn8IXEFtj7O?=
 =?us-ascii?Q?aLtNmk+TAod86ab3Y5OKglhyeATmfc6qQG45pPIhUIlDdOF2cPVv7HOO1bPH?=
 =?us-ascii?Q?MvIPNjm3iyK+7Umli1mf+mUAY/nE2RtNzostpv1h68OdJrC73xhTLDtiAszD?=
 =?us-ascii?Q?8yXH6J/TY2O1yFtk9OlJF3Mw9rYQQw6k3mAPbV2NqGFeNH5Eg1psvSC2hJDu?=
 =?us-ascii?Q?LdRe/qT8OgwH1B5U25ViNLDkANILRQ74Uowo8LQ2cFuvuzgnY3PUh46Wsxrm?=
 =?us-ascii?Q?RWXaowxVuAcRK1L5+5Egs7+FItNq+/yGs8zWKbGl6vTaI8okEPsubX+PfK6H?=
 =?us-ascii?Q?IW145nIwJk/36zEveKCOrVCvTw3oACXZtVHfEQE1pI10QJXxdGoYUIWSyAcK?=
 =?us-ascii?Q?gm8jlVGyMSnhBP0SLKQ5Tk3oAyF5prMzn+3lQ/8MfVh/xEr1nPl6dEDWyE0J?=
 =?us-ascii?Q?UOHtfSk8dhzArgEENUQizaFtiV0fdzqNZQCm6GMzBDojtkHHvrIC5L7PFkeL?=
 =?us-ascii?Q?aGq06expDyOm94t5He8jlhlOkKzG80tJhtSDwX259qHn1RVAHQaFFDl6gNo8?=
 =?us-ascii?Q?M4fQNl4tHrm+Bz10Ijbi7+HrwS8sw/4Wj0t7VRP+GMdgvZRWOl72+VyvKISK?=
 =?us-ascii?Q?RQoHH3qHbEK9cfX5zsEFg3NsCl+u7Y69YaANIXhM3tGoYHvSWizhkH9gbk+j?=
 =?us-ascii?Q?Qa7Wm2WYV5W5EvOW4cutnbSOslvQLo6SJEsBOPcP?=
Content-Type: multipart/alternative;
	boundary="_000_SEZPR01MB5748AB66F48B9A164728F4A0EA90ASEZPR01MB5748apcp_"
MIME-Version: 1.0
X-OriginatorOrg: unitel.mn
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: 
 SEZPR01MB5748.apcprd01.prod.exchangelabs.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 e557a812-601b-4df3-0f1c-08dd9378ca0a
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 May 2025 06:21:55.1333
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b3ebfd0f-c92a-40d3-8239-1122fa66f590
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 g9uhXrwn44Qm1a0RdnVVSyMHlekTEntWbmIJ+xSQBgbYJDrJMyRuKjzZm+bEsB7mKM4trXMhx/aAL5rPpgFFhA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY1PPFA69CD3E42
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/SEZPR01MB5748AB66F48B9A164728F4A0EA90A%40SEZPR01MB5748.apcprd01.prod.exchangelabs.com>
Precedence: bulk

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

Hello Postgres Community,

My PostgreSQL is a cluster that managed by Patroni and etcd. While it has 2=
 replica server both of the replica's are holding huge amount of WAL file (=
current 55GB since 29th April). I've checked the replay delay, wal_keep_siz=
e, replication slot, max_wal_size but all of them were fine there's no slot=
 keeping that wal in replica for sure even in master there's no slot holdin=
g that WAL, wal_keep_size is 5GB and max_wal_size is 8GB and delay is almos=
t 0.02 second almost no delay. But there's no that size of WAL in master no=
de. What's the troubleshoot of this case, how to check it?

Sincerely,

Mendbayar A.

--_000_SEZPR01MB5748AB66F48B9A164728F4A0EA90ASEZPR01MB5748apcp_
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:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
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">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello Postgres Community, <br>
<br>
My PostgreSQL is a cluster that managed by Patroni and etcd. While it has 2=
 replica server both of the replica&#8217;s are holding huge amount of WAL =
file (current 55GB since 29<sup>th</sup> April). I&#8217;ve checked the rep=
lay delay, wal_keep_size, replication slot,
 max_wal_size but all of them were fine there&#8217;s no slot keeping that =
wal in replica for sure even in master there&#8217;s no slot holding that W=
AL, wal_keep_size is 5GB and max_wal_size is 8GB and delay is almost 0.02 s=
econd almost no delay. But there&#8217;s no that size
 of WAL in master node. What&#8217;s the troubleshoot of this case, how to =
check it?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span style=3D"font-size:8.0pt;font-family:&quot;Ari=
al&quot;,sans-serif;color:#595959">Sincerely,</span><o:p></o:p></p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:10.0pt;font-family:&quot=
;Arial&quot;,sans-serif;color:black"><br>
Mendbayar A.</span></b><span style=3D"font-family:&quot;Arial&quot;,sans-se=
rif;color:#1F497D"><o:p></o:p></span></p>
</div>
</body>
</html>

--_000_SEZPR01MB5748AB66F48B9A164728F4A0EA90ASEZPR01MB5748apcp_--