From: | Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com> |
---|---|
To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Free disk space decreasing after running Vaccum Full |
Date: | 2024-06-28 16:07:20 |
Message-ID: | DB4PR10MB7469448FDC9519F990069CDA8CD02@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello ,
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
Send
To:
________________________________
From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Sent: 28 June 2024 17:57
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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.
On Fri, Jun 28, 2024 at 7:53 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com<mailto:ronljohnsonjr(at)gmail(dot)com>> wrote:
On Fri, Jun 28, 2024 at 9:58 AM Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com<mailto:mukherjee(dot)sabyasachi(at)outlook(dot)com>> 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(dot)oliver(at)gmail(dot)com<mailto:wellsoliver(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2024-06-28 16:14:36 | Re: Free disk space decreasing after running Vaccum Full |
Previous Message | Wells Oliver | 2024-06-28 15:57:13 | Re: Free disk space decreasing after running Vaccum Full |