Re: Re: DB size value different than "/data" dir size

On Mon, 2025-08-11 at 14:13 +0000, Ghiurea, Isabella wrote:
> I believe this is related to VACUUM FULL behavior in a streaming replication cfg ,
> for the standby server the space is not been reclaimed , But the sieze of db reported
> with pg_pretty_db_size is identical on both db size but is  not the actual sum of
> /var/lib/pgsql/data1 files +dir size on the active PG were vacuum full reclaim the space.
>
> Is this a normal behavior  in PG with reporting incorrect db size if vacuum full has
> not reclaim the OS disk space on both server?

VACUUM (FULL) will also reclaim the size on the standby.
There can be some delay in the case of a replication conflict.

Yours,
Laurenz Albe