Partitioning: Drop non-partitioned project_daily_statistics table

Background

Related to: Source Code: Table Cleanup: Partition project_d... (&18879 - closed)

The project_daily_statistics table stores daily aggregated metrics for GitLab projects. Due to the rapidly increasing table size, we decided to partition this table to improve performance and manageability.

This is the final step (step 6) of the partitioning process. At this point, the application should be successfully using the partitioned table, and the original non-partitioned table is no longer needed. Now we are ready to drop the old table.

To-Do

1. Verify application is fully migrated to partitioned table
2. Monitor for any remaining references to old table
3. Drop the non-partitioned project_daily_statistics table

resources:

1. partitioning
2. Replace ci_runner_machines with partitioned table