logoalt Hacker News

radarroarklast Wednesday at 12:33 PM0 repliesview on HN

The fastest approach is to just zero out the data. Alternatively you can rebuild the entire database while preserving only the data accessible in the latest copy of the db (kinda similar to SQLite's VACUUM command).