>>> 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
