I have a huge table that I cannot delete the rows, only update the columns that are storing huge base64 data, that I should update to null to try to release space.
So I programmed a script that are able to set all the images in base64 expecting that the space will be released after Vacuum!
The images are set to null, vacuum executed, but the table is still with the exactly same size, and I am pretty sure the space must be released immediately, so what I am doing wrong?
Will vacuum full able to release space from huge varchar data that I updated to null? (Because I will need to lock the table if I will do this and I need to be sure)
The dump size decreased by 10 times so I expect similar behavior on the database size.