|
I am doing a vacuum full on a table that takes up 78 GB of a
79 GB HD. When I couldn’t add any more data because of out of disk space
errors, I freed up space by dropping other tables in the database. I was able
to delete about half the records in the table, but the space consumption did
not change. I began a vacuum full on the individual table on 3/15 and the hard
drive light hasn’t turned off since then. df –h reports 806 MB free and 79 GB used. Is this
enough free space to perform a vacuum? Should I export the table, drop it, and
re-import it? I have implemented data retention policies to keep the
amount of data in the table to a more reasonable level in the future and would
like to retain what is currently in there, but will not be heartbroken to lose
it. Many thanks for any tips or advice provided. Robert |
