DB size value different than "/data" dir size

From: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: DB size value different than "/data" dir size
Date: 2025-08-08 23:17:19
Message-ID: aa68b26ba58b43c980648d76c27f4ce9@nrc-cnrc.gc.ca
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List,

I am running PGSQL version 12.3 cfg master-slave with streaming replication and I am facing a issue in the present active Pg db.

The database size reported from the following : pg_size_pretty() or pg_database_size() or sum all of db objects is grater than the sum size of all directories/files reported under /var/lib/pgsql/data1/tbl_space_name/PG_12,,,xxx/ . ( db data tablespace)

[ Mention in standby PG db the size matches the /data sum file size and also matches with the size reported in Pg active for pg_size_pretty() or pg_database_size ]

What can be the issue?

thank you !

Isabella

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-08-08 23:30:44 Re: DB size value different than "/data" dir size
Previous Message Wasim Devale 2025-08-06 19:33:47 Pg_logical