David Ondrejik <David(dot)Ondrejik(at)noaa(dot)gov> wrote:
> So I had to kill my process, recover disk space and get the
> machine back in working condition for the weekend. I guess I will
> attempt to do the full vacuum again next week.
Why do you think that you need a VACUUM FULL? That is only needed
as an extreme measure in rather unusual circumstances. We run
hundreds of PostgreSQL databases, and have not used VACUUM FULL for
years. On the other hand, we VACUUM ANALYZE most databases in their
entirety every night. (Be very careful not to confuse VACUUM FULL
with vacuum of an entire database.)
On the other hand, the failed attempt at VACUUM FULL may have
bloated your indexes, so you might want to REINDEX the table next
week, followed by a VACUUM ANALYZE (without the FULL).
-Kevin