Skip to main content
Tweeted twitter.com/StackDBAs/status/1595069594598776836
added 88 characters in body
Source Link
ITChap
  • 229
  • 3
  • 9

I made small miscalculation and my VACUUM FULL ended up filling the disks of the instance. I managed to free enough space to restart postgres but I am afraid it won't be enough to run VACUUM FULL to completion.

Is there any way to free the space used by the failed VACUUM FULL run?

PS: Here is the options that I used VACUUM (FULL, VERBOSE, ANALYZE, INDEX_CLEANUP)

I made small miscalculation and my VACUUM FULL ended up filling the disks of the instance. I managed to free enough space to restart postgres but I am afraid it won't be enough to run VACUUM FULL to completion.

Is there any way to free the space used by the failed VACUUM FULL run?

I made small miscalculation and my VACUUM FULL ended up filling the disks of the instance. I managed to free enough space to restart postgres but I am afraid it won't be enough to run VACUUM FULL to completion.

Is there any way to free the space used by the failed VACUUM FULL run?

PS: Here is the options that I used VACUUM (FULL, VERBOSE, ANALYZE, INDEX_CLEANUP)

Source Link
ITChap
  • 229
  • 3
  • 9

Reclaim space after a failed VACUUM FULL

I made small miscalculation and my VACUUM FULL ended up filling the disks of the instance. I managed to free enough space to restart postgres but I am afraid it won't be enough to run VACUUM FULL to completion.

Is there any way to free the space used by the failed VACUUM FULL run?