1603229 - Delete pushes older than a year

Status: RESOLVED DUPLICATE of bug 1599859

(Tree Management :: Treeherder: Infrastructure, defect)

Description

[Armen [:armenzg]]

There's currently 400k pushes older than a year [1]. Most of them should not have any related data to it but I could be wrong. I believe deleting a push also deletes all associated data to it [2].

Deleting pushes & related data older than a year will probably simplify the code for cycle_data around performance data.

[1]

>>> len(Push.objects.filter(time__lt='2018-12-11 20:00:00.000000'))
411763

[2]

Push.objects.filter(time__lt='2010-01-11 20:14:59.000000')[0].delete()
(1, {'model.Commit': 0, 'perf.PerformanceDatum': 0, 'model.Push': 1})