Dear DELETE
summary
Talk discusses practical issues of deleting or moving large amounts of unwanted data from databases (millions of rows). It examines why a simple SQL DELETE with an index can fail in real systems and covers approaches and operational practices for safe, efficient deletion and migration of data to cheaper storage.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 3:18Mass data deletion problem
- 7:35Mistake 1: no review
- 9:19Checkpoint tuning: what and why
- 14:43Checkpoint tuning experiments
- 21:50Mistake 4: no DELETE batching
- 26:52DELETE batching strategies
- 31:15Mistake 5: weak monitoring
- 35:10Testing and automation tools
- 36:37Hands-on session and invite
- 37:22Q&A
related talks
48mThe DB tamer
24mData Deletion at Facebook
33mUNDELETE data FROM table;
54mLessons learned from refactoring multi terabyte databases for the last 10 years
26mBiggish Data With Rails and Postgresql
38mEfficient Reliable Database Migration: A Legacy Innovation Story
47mMy Database Can't Handle the Load. What to Do?
46mBig Data. Or Just Too Much Data?