How I redesigned a push notification logging system that had accumulated 100 million rows — without a single minute of downtime — using a summary table pattern, idempotent aggregation, and safe batch deletion.


When your push notification service sends 500,000 messages per job and those logs never get cleaned up, you end up with 100 million rows...