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