MIME-Version: 1.0
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>
In-Reply-To: <db46ab37a8ca7bcae168ed45e73c4d68908993ab.camel@cybertec.at>
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Mon, 15 Jun 2026 14:28:01 +0530
Message-ID: 
 <CAJk5AtZfFBqLfKyz7rAqJOXT0ZvEXna19wMn==YCin-PLUGiXw@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="000000000000c854f10654470669"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtZfFBqLfKyz7rAqJOXT0ZvEXna19wMn%3D%3DYCin-PLUGiXw%40mail.gmail.com>
Precedence: bulk

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

The command du -ch 327101*  picks all files 327202, 327101.1, 327101.2
.......and give each of them sizes and also total size of all files listed
as u see in my earlier screenshot

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

> On Mon, 2026-06-15 at 06:48 +0530, Raj wrote:
> > 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?
> >
> > No, I am using the command du -ch 327101*
>
> That reply does not make any sense to me.
>
> Yours,
> Laurenz Albe
>

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

<div dir=3D"auto"><div>The command du -ch 327101*=C2=A0 picks all files 327=
202, 327101.1, 327101.2 .......and give each of them sizes and also total s=
ize of all files listed as u see in my earlier screenshot<br><br><div class=
=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr=
">On Mon, 15 Jun 2026, 11:47 Laurenz Albe, &lt;<a href=3D"mailto:laurenz.al=
be@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">On Mon, 2026-06-15 at 06:48 +0530, Raj wrote:<br>
&gt; On Mon, 15 Jun 2026, 01:00 Laurenz Albe, &lt;<a href=3D"mailto:laurenz=
.albe@cybertec.at" target=3D"_blank" rel=3D"noreferrer">laurenz.albe@cybert=
ec.at</a>&gt; wrote:<br>
&gt; &gt; On Sat, 2026-06-13 at 12:18 +0530, Raj wrote:<br>
&gt; &gt; &gt; I took one big sample table which is 73GB, and using relfile=
node(327683) I tried finding the<br>
&gt; &gt; &gt; underlying file size du -sh 327683*=C2=A0 and able to find t=
he total size the files occpuing and<br>
&gt; &gt; &gt; found 113gb.......so for one table itself it is 40Gb additio=
nal...<br>
&gt; &gt; <br>
&gt; &gt; Investigate more:<br>
&gt; &gt; <br>
&gt; &gt; - Make sure that you don&#39;t get files from another filenode li=
ke 3276838.<br>
&gt; &gt; <br>
&gt; &gt; - If the relation (as shown by pg_relation_size(&#39;tablename=
9;)) is 73GB,<br>
&gt; &gt; =C2=A0 it should consist of 327683, 327683.1, 327683.2, ..., 3276=
83.72.<br>
&gt; &gt; =C2=A0 Check what additional files there are.<br>
&gt; &gt; <br>
&gt; &gt; - Extra files can be left behind after a crash.=C2=A0 Were there =
any?<br>
&gt;<br>
&gt; No, I am using the command du -ch 327101*<br>
<br>
That reply does not make any sense to me.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div></div>

--000000000000c854f10654470669--