Re: Free disk space decreasing after running Vaccum Full

[Wells Oliver <wells.oliver@xxxxxxxxx>]

VACUUM FULL is designed to release disk space back to the OS by rebuilding the table. Unless I misunderstand, this is the effect and desired intent.

On Fri, Jun 28, 2024 at 7:53 AM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:

On Fri, Jun 28, 2024 at 9:58 AM Sabyasachi Mukherjee <mukherjee.sabyasachi@xxxxxxxxxxx> wrote:

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?

 

3. VACUUM FULL should only be run after deleting or updating a significant portion of a table.

--

Wells Oliver
wells.oliver@xxxxxxxxx