Message-ID: <9e1ebefd12e1fc955eee580caca5e9c37fd005ca.camel@cybertec.at>
Subject: Re: DB size  value different than  "/data"  dir size
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>,
 "pgsql-admin@postgresql.org"
	 <pgsql-admin@postgresql.org>
Date: Sun, 10 Aug 2025 21:27:31 +0200
In-Reply-To: <aa68b26ba58b43c980648d76c27f4ce9@nrc-cnrc.gc.ca>
References: <aa68b26ba58b43c980648d76c27f4ce9@nrc-cnrc.gc.ca>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/9e1ebefd12e1fc955eee580caca5e9c37fd005ca.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-08-08 at 23:17 +0000, Ghiurea, Isabella wrote:
> I am running=C2=A0 =C2=A0PGSQL version 12.3=C2=A0 =C2=A0cfg=C2=A0=C2=A0=
=C2=A0master-slave=C2=A0 with=C2=A0 streaming replication
> and I am facing a issue in the present active Pg db.=C2=A0
> The database size reported from=C2=A0 the following :=C2=A0pg_size_pretty=
() or pg_database_size()
> or sum all of db=C2=A0 objects is=C2=A0 grater than the=C2=A0 sum size of=
=C2=A0 all=C2=A0directories/files
> reported=C2=A0 under /var/lib/pgsql/data1/tbl_space_name/PG_12,,,xxx/ .=
=C2=A0 ( db data tablespace)

Perhaps some part of the data is in a different tablespace, maybe pg_defaul=
t.

Yours,
Laurenz Albe