4 ms·

well there is truncate for that. (not mvcc safe)

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