Chore: Drop old non-partitioned duo_workflows_checkpoints table

Summary

Remove the legacy non-partitioned duo_workflows_checkpoints table after confirming all data migration is complete and historical analysis requirements are met.

Context Following the successful implementation of:

We can now decommission the old non-partitioned table to free up database resources.

Problem Statement

The old non-partitioned duo_workflows_checkpoints table is no longer in use but continues to consume database storage and resources. We need to safely remove it while ensuring no data loss or disruption to historical analysis. Prerequisites

  • Partitioning MR fully deployed and stable
  • Switch MR completed with all traffic using new partitioned table
  • At least 30 days of stable operation on new table
  • Target date: After August 11th, 2025

Proposed Solution

  • Drop the old table including all indexes and foreign keys

Acceptance Criteria

  • Team confirms historical analysis needs are met
  • Old table successfully dropped andDatabase storage reclaimed
Edited by 🤖 GitLab Bot 🤖