This is what I was thinking but I am worried about two things.
1. If there is a very large set of data in the table that needs to be moved this will be slow and might throw locks which would impact the performance of the inserts and the updates.
2. Constantly deleting large chunks of data might cause vacuum problems.