Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZjbr-001FLO-0T for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jun 2026 06:18:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZjaq-004hEQ-05 for pgsql-admin@arkaria.postgresql.org; Wed, 17 Jun 2026 06:17:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZjap-004hEG-2B for pgsql-admin@lists.postgresql.org; Wed, 17 Jun 2026 06:17:43 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wZjao-00000000lIm-1Vcl for pgsql-admin@lists.postgresql.org; Wed, 17 Jun 2026 06:17:42 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-3995e22ef81so5647511fa.1 for ; Tue, 16 Jun 2026 23:17:41 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781677059; cv=none; d=google.com; s=arc-20240605; b=Fk9dx6x0jUAQZ+zD9/mj7DVnhrzhntvpOoFNIAgXeDytGWfclBxnhUyY8EElM4KQCY s+ymt24WiHh8ufTmd9fYpka2T5QzRBeH67pTSPUZqJ4Mi+WMF9OUvaW7b/jvq/2u9tbw RhJD9XD7d2LwqaiP/I7qQXbO3E4ykxw+ncL2tj5Jeqr+e417CCI/8EC9o9zFaL/HV9MM h+cdaqi8O2jkl66CveyhbJPmsWu48zMKbCPuY3soceH3JPt9CIKpok2HS+4mVaoaVXw3 iLKaBWc8UNvFZJyyZv3+3nrwuxH2AdCRm8Afy3HqNpEqfaKwf45OYFPdIEe2gi4tu0AM 080g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=qIaN0XKm5fzZCY5oSyuVeDs24AFr2ROrEoE8raBK6ic=; fh=w+NdVitGKczCsjwXWKDGhV4AmoWb4l6r06tzxs/Zo9k=; b=Y429Y8owQegp2/kBlSxytExOhzFoX+VhRtdTbpMZs8l2pf/gZUygyfHakuK6dvmBNi ZmtpP8qwbDYAELz4k33zGwwe/bbvGLG+Q+IAzBNUzSVw206qT2hANU/HXBBjfkmpvYTQ Bk/bd/G9x5xhb98dluZGnzf9vgnEGperLy24392oiMh+xjkfF2lE8AK+aOUCtOHSeG1R 72MRmG6E5cr11TN45JQWk/6Ur87IMABqSoB3B/PfJWuCmVJIa+KvxEP4cWCZj40BL6c0 5OrmNOE5qYS/cbHoy1UCzTKgtfK2TNb0DnuzeSLPsXgtRyUJYFiVLnP3f49T76Imv8pp 9VkA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781677059; x=1782281859; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=qIaN0XKm5fzZCY5oSyuVeDs24AFr2ROrEoE8raBK6ic=; b=B/NmvFCuyyTuHGQWRvu/EMNumdb9PGl/WEc3FghgTGC4q1tNaT8Gg8g20F1IAhwFU5 qnmaz0PeLN+zyhDFYi+XtfI1Z6GPJI9z94gVf93450SSx4w9Kh+PABaPVOYm1evUbFFM bSN2tNgkrLTZi3Lk7PzDW3u6mEr+9HpG6U04DAAAR1t8j0i8/Za9eoiSuwytRl8JVGTA axBlq+X1ZFOhgM9YcpwKjM1xUpRYiO69+X1i0L88i2zOq+yamtpbVJ/idMm/bETpCw82 MT8r8ocr6VCUCdyqscnOC0rccEYdloQ8KtluA4ZnNvwres9wKuAW9JZooTWJ3li1xFR0 GpTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781677059; x=1782281859; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=qIaN0XKm5fzZCY5oSyuVeDs24AFr2ROrEoE8raBK6ic=; b=mDDkxJ2e11Lez9ZzJ4aHWfL3EltVM2yXyGK/O45MHuD+Of52LQgFR6mhy2cqgORaZN n/5KRwSI75GeCSYBm2nKfsRGmVx+LBUOWFJTDDpc9XypidJt4agjHcnGPsWomFWRKRsc Y8/Pj4oG1HMS6A2oR//NL3lU1RLRs4XfXnZPcuphcCabRLqIJDO5Kq6vIFqPlEB9+s19 7xhBK4YXounmXYlzJ3pDSlyNp//Hmeu+H44vHp3Ari+9LiujwvXUjCIZ1M0NFKOnAhgE r8fABD3pAUL3oz8nkK2IRdPl3znGHQE56JB5KJxr5g68pDHRmcq90z9XWEJh+LWAXqYM RMuw== X-Gm-Message-State: AOJu0Yw3uKv2LDOfhOsJ2fIiOxlxGbtzEcnXStXbBi98YUZJB4FTjSte s7cnChH8+rQlVTZBMet5W11a2ELkV+A8GK20AhOqIxAZJrxhL4Vil7QzahdQZKjqa4GnzpKlO0V DTEdlGjxX8Fp/s0roDKS7jraldK+dCVBrxQ== X-Gm-Gg: Acq92OFKd1XvOHioHQNTXNOxrF0Dl4m3+JhYTYONJRwOkXoc/7DWvr6OxljJm0FsIOE hg8eaTqAIzQ88rhrDn6J8aDspwFV5qkLSzt0hK7R5BeV7lgpzpbN21vt6BrTlO+t6+hZMQm3qsJ mehyacC3kxrtQGDG79s0CkBJdhanwCvXleHrAwe7Q5qWae0Fx5wZr276bDpA6da6vmu/2Iq9Hp0 7460CsAD4mu/CBQ1Nj0XKwSX6PmQ4DtOUu3LI+QT0XWbBD2IaSXyd0UbxsyKnopdjFYkUogN/OD OLEROwA6nPYvskua3S3D60o0YsJy2GY= X-Received: by 2002:a05:651c:150d:b0:396:746d:a993 with SMTP id 38308e7fff4ca-39969ea7e6emr5036991fa.0.1781677058383; Tue, 16 Jun 2026 23:17:38 -0700 (PDT) MIME-Version: 1.0 References: <3a2c4d549587beb3528f6ce09b3d4c448d32f8ee.camel@cybertec.at> In-Reply-To: From: Raj Date: Wed, 17 Jun 2026 11:47:24 +0530 X-Gm-Features: AVVi8CfVX89EuHcgNPSqCEibHKLRSLvDKo9Mup5siMjNoATOqw0G0XYnSywwvSk Message-ID: Subject: Re: Size of /pgdata To: Laurenz Albe Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000002b62d706546d0418" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002b62d706546d0418 Content-Type: text/plain; charset="UTF-8" The file count is same between them..but the file size varies. For example, assume node1 has issue and node2 is clean. 1. On both nodes file count is 76 2. File size varies for some of them Each files are either 1GB or 2GB and some or them are 1.2gb or 1.5gb or between 1-2gb ....by looking at files.. In the problematic node, some of the 1gb files in node2 shows 2GB in node1...and also file size differences. making the difference. On Tue, 16 Jun 2026, 19:14 Laurenz Albe, wrote: > On Tue, 2026-06-16 at 15:30 +0530, Raj wrote: > > Moreover in a 3 node PATRONI...other two nodes are didn't have this > issue.... > > only one node has this issue of disk space difference of around 200gb > > Well, figure out which files are different. > > Perhaps you had a crash on one of the nodes that left some orphaned files > around. > > Yours, > Laurenz Albe > --0000000000002b62d706546d0418 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
The file count is same between them..but the file size va= ries.

For example, assume node= 1 has issue and node2 is clean.

1. On both nodes file count is 76
2. File = size varies for some of them

Each files are either 1GB or 2GB and some or them are 1.2gb or 1.5gb o= r between 1-2gb ....by looking at files..
=C2=A0In t= he problematic node, some of the 1gb files in node2=C2=A0 shows 2GB in node= 1...and also file size differences. making the difference.

<= div class=3D"gmail_quote">
On Tue, 16 = Jun 2026, 19:14 Laurenz Albe, <laurenz.albe@cybertec.at> wr= ote:
On Tue, 2026-06-16 at 15:30 +0= 530, Raj wrote:
> Moreover in a 3 node PATRONI...other two nodes are didn't have thi= s issue....
> only one node has this issue of disk space difference of around 200gb<= br>
Well, figure out which files are different.

Perhaps you had a crash on one of the nodes that left some orphaned files a= round.

Yours,
Laurenz Albe
--0000000000002b62d706546d0418--