Re: Free disk space decreasing after running Vaccum Full

Yes it will decrease as it removes the fragmentation and dirty from existing table.

If you're in cloud environment, it can be done easily from cloud console

[ACT] Idelette Tchakounte
Sr Database Administrator
Advanced Call Center Technologies, LLC
itchakounte(at)acttoday(dot)com<mailto:itchakounte(at)acttoday(dot)com>

________________________________
From: Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com>
Sent: Friday, June 28, 2024 9:58:34 AM
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Free disk space decreasing after running Vaccum Full

CAUTION

This is an external email originating from outside of ACT; do not click links or open attachments unless you know the content is safe.

Hello All,
The disk space is decreasing drastically after running "Vaccum Full".
I was expecting increase of free disk space after running those commands. I am on Postgresql 16.1
Any guidance/advise?

Sabyasachi Mukherjee