>>> Alexy Khrabrov wrote:
> OK. I've cancelled all previous attempts at UPDATE and will now
> create some derived tables. See no changes in the previous huge
table
> -- the added column was completely empty. Dropped it. Should I
> vacuum just in case, or am I guaranteed not to have any extra rows
> since no UPDATE actually went through and none are showing?
The canceled attempts would have left dead space. If you have
autovacuum running, it probably made the space available for reuse,
but depending on exactly how you got to where you are, you may have
bloat. Personally, I would do a VACUUM ANALYZE VERBOSE and capture
the output. If bloat is too bad, you may want to CLUSTER the table
(if you have the free disk space for a temporary extra copy of the
table) or VACUUM FULL followed by REINDEX (if you don't have that much
free disk space).
Let us know if you need help interpreting the VERBOSE output.
-Kevin
