Lately I had to migrate pretty fat (300GB+ data and 150GB+ of index data) postgres table - application grew, we had to get rid of one pretty big column that was redundant now, change main composite index, change one column type etc. etc. The problem was - do it without significant amount of downtime. You can google up tons of solutions, but let me walk through approach I chose - hopefully you will find it somewhat useful.