Thanks for your response. I am running vacuum full schema_name.table_name.
And after each table run - the amount of free space in the disk in decreasing.
Though I am not deleting any rows from the table.
Sabyasachi Mukherjee
Press Alt+Down for more options
From: Wells Oliver <wells.oliver@gmail.com> Sent: 28 June 2024 17:57 To: Ron Johnson <ronljohnsonjr@gmail.com> Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org> Subject: Re: Free disk space decreasing after running Vaccum Full
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.