[teej]

The table needed to never be visible as empty, so truncate wasn't a short term option.

[takeda]

I solved this by using partitions (at the time it was done through inheritance, where you could make one table made out of several smaller ones), and just dropping a table with unneeded data.