Message-ID: <ce3c4c54edfd1e5d451bc0605b71fd94f99215eb.camel@cybertec.at>
Subject: Re: Size of /pgdata
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Wed, 17 Jun 2026 13:34:23 +0200
In-Reply-To: 
 <CAJk5AtarTco=DXJw8qDOe_CET5hUApb-aEJr5xL2pEAFgnsdNQ@mail.gmail.com>
References: 
	<CAJk5Atb1v7=x-wsS-tL7Lxs7yXQy8Ng-GhXG+zzZ1gVAx=Xzjw@mail.gmail.com>
	 <e55acd6eb1b237f1293b0150f60e1655a8778724.camel@cybertec.at>
	 <CAJk5AtburOY2ugaH-6+8OHgOBwyyaq1V3LLozCAf57c5jtmR+w@mail.gmail.com>
	 <db46ab37a8ca7bcae168ed45e73c4d68908993ab.camel@cybertec.at>
	 <CAJk5AtZfFBqLfKyz7rAqJOXT0ZvEXna19wMn==YCin-PLUGiXw@mail.gmail.com>
	 <3a2c4d549587beb3528f6ce09b3d4c448d32f8ee.camel@cybertec.at>
	 <CAJk5AtZQ-4Wg0vnYLO5BJJntMG1oBEmvediAYQKXj0OL6MsOww@mail.gmail.com>
	 <e988960a1d5dbf7b483c1374bce04351ff6f1dd3.camel@cybertec.at>
	 <CAJk5AtarTco=DXJw8qDOe_CET5hUApb-aEJr5xL2pEAFgnsdNQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/ce3c4c54edfd1e5d451bc0605b71fd94f99215eb.camel%40cybertec.at>
Precedence: bulk

On Wed, 2026-06-17 at 11:47 +0530, Raj wrote:
> The file count is same between them..but the file size varies.
>=20
> For example, assume node1 has issue and node2 is clean.
>=20
> 1. On both nodes file count is 76
> 2. File size varies for some of them
>=20
> Each files are either 1GB or 2GB and some or them are 1.2gb or 1.5gb or b=
etween 1-2gb ....by looking at files..
> =C2=A0In the problematic node, some of the 1gb files in node2=C2=A0 shows=
 2GB in node1...and also file size differences. making the difference.

That is highly suspicious.

What do you get if you run

  SHOW segment_size;

Unless you built PostgreSQL yourself after changing the segment size,
it should be 1GB.  But then it would be impossible for some segment
to be bigger than 1GB.

Are you using some weird file system that reports file sizes wrongly?

What does "ls -l" on one of these big files show?

Yours,
Laurenz Albe