MIME-Version: 1.0
References: 
 <CAJk5Atb1v7=x-wsS-tL7Lxs7yXQy8Ng-GhXG+zzZ1gVAx=Xzjw@mail.gmail.com>
 <e55acd6eb1b237f1293b0150f60e1655a8778724.camel@cybertec.at>
In-Reply-To: <e55acd6eb1b237f1293b0150f60e1655a8778724.camel@cybertec.at>
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Mon, 15 Jun 2026 06:48:23 +0530
Message-ID: 
 <CAJk5AtburOY2ugaH-6+8OHgOBwyyaq1V3LLozCAf57c5jtmR+w@mail.gmail.com>
Subject: Re: Size of /pgdata
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fe77570654409ab7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtburOY2ugaH-6%2B8OHgOBwyyaq1V3LLozCAf57c5jtmR%2Bw%40mail.gmail.com>
Precedence: bulk

--000000000000fe77570654409ab7
Content-Type: text/plain; charset="UTF-8"

No, I am using the command du -ch 327101*

On Mon, 15 Jun 2026, 01:00 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:

> On Sat, 2026-06-13 at 12:18 +0530, Raj wrote:
> > I took one big sample table which is 73GB, and using relfilenode(327683)
> I tried finding the
> > underlying file size du -sh 327683*  and able to find the total size the
> files occpuing and
> > found 113gb.......so for one table itself it is 40Gb additional...
>
> Investigate more:
>
> - Make sure that you don't get files from another filenode like 3276838.
>
> - If the relation (as shown by pg_relation_size('tablename')) is 73GB,
>   it should consist of 327683, 327683.1, 327683.2, ..., 327683.72.
>   Check what additional files there are.
>
> - Extra files can be left behind after a crash.  Were there any?
>
> Yours,
> Laurenz Albe
>

--000000000000fe77570654409ab7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">No, I am using the command du -ch 327101*</div><br><div c=
lass=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_=
attr">On Mon, 15 Jun 2026, 01:00 Laurenz Albe, &lt;<a href=3D"mailto:lauren=
z.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc=
 solid;padding-left:1ex">On Sat, 2026-06-13 at 12:18 +0530, Raj wrote:<br>
&gt; I took one big sample table which is 73GB, and using relfilenode(32768=
3) I tried finding the<br>
&gt; underlying file size du -sh 327683*=C2=A0 and able to find the total s=
ize the files occpuing and<br>
&gt; found 113gb.......so for one table itself it is 40Gb additional...<br>
<br>
Investigate more:<br>
<br>
- Make sure that you don&#39;t get files from another filenode like 3276838=
.<br>
<br>
- If the relation (as shown by pg_relation_size(&#39;tablename&#39;)) is 73=
GB,<br>
=C2=A0 it should consist of 327683, 327683.1, 327683.2, ..., 327683.72.<br>
=C2=A0 Check what additional files there are.<br>
<br>
- Extra files can be left behind after a crash.=C2=A0 Were there any?<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--000000000000fe77570654409ab7--