1665857 - [meta] Address data retention in Perfherder

Status: RESOLVED FIXED

(Tree Management :: Perfherder, task, P3)

Description

[Ionuț Goldan [:igoldan]]

In bug 1346567, we managed to re enable the expiring algorithm for perf data.

It's main mechanics are working up to this day. We're now keeping the performance_datum table at ~300 million rows (while previously it peaked at >750 million).

However, there are other tweaks we could employ to further expire useless perf data. So we have more decent sized tables (performance_datum, performance_signature, performance_alert_summary).

Comment 1

[Ionuț Goldan [:igoldan]]

Outcome of this meta:

• reduced perf datum table from ~300 million to ~140 million rows
• we're now expiring empty alert summaries as well
• we're now expiring perf signatures which no longer have any points

Comment 2

[Sarah Clements [:sclements]]

That's great - thanks!