around 150 million rows will be kept i.e. last three months data.

I am thinking about taking those rows into another table and then truncating/dropping the table and renaming the actual table.

But the problem is that this table is used for insertions, so there is a chance of data loss