From: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
To: Wells Oliver <wells.oliver@gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Free disk space decreasing after running Vaccum Full
Date: Fri, 28 Jun 2024 16:07:20 +0000
Message-ID: <DB4PR10MB7469448FDC9519F990069CDA8CD02@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAOC+FBVAiULBGsNbsfyWGEXx5B8fvgBrkUMKb+s=86uBfQVG3g@mail.gmail.com>
References: <DB4PR10MB7469EDA3FFCD73EE3C93B3E98CD02@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
<CANzqJaB_h73x7rGKNEOCFuo8fno_-UpEeMuPRdxR3OhCFnVeXg@mail.gmail.com>
<CAOC+FBVAiULBGsNbsfyWGEXx5B8fvgBrkUMKb+s=86uBfQVG3g@mail.gmail.com>
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.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.
On Fri, Jun 28, 2024 at 7:53 AM Ron Johnson <ronljohnsonjr@gmail.com<mailto:ronljohnsonjr@gmail.com>> wrote:
On Fri, Jun 28, 2024 at 9:58 AM Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com<mailto:mukherjee.sabyasachi@outlook.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.oliver@gmail.com<mailto:wellsoliver@gmail.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mukherjee.sabyasachi@outlook.com, wells.oliver@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Free disk space decreasing after running Vaccum Full
In-Reply-To: <DB4PR10MB7469448FDC9519F990069CDA8CD02@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox