Hacker News new | ask | show | jobs
by merb 2075 days ago
well there is truncate for that. (not mvcc safe)
1 comments

The table needed to never be visible as empty, so truncate wasn't a short term option.
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.