Select data from table join or UDPATE?
I would think that Option 2 is more preferable because of the following:


Less overall writes to the database (no extra table required)
Less overall WAL activity (Option 1 involves both an INSERT/COPY and an UPDATE for each row involved)


In either case, you could encounter some table bloat, in which case you'd want to make sure you VACUUM after doing this operation.