Links to the schema on master:
Should this table be replicated to wiki replicas (does it not contain private data)?
The table does not contain private data.
Will you be doing cross-joins with the wiki metadata?
No
Size of the table (number of rows expected).
- automoderator_model: 1 row per wiki to start
- automoderator_rev_score: Actual number TDB: the size will be proportional to the recent changes table on each project. We will score most revisions and store those scores here.
- automoderator_model: 8 rows per wiki per year would be generous. This will grow by the number of models we use times the number of version increments per model. For now we are using a single model, and we only see potentially adding one more within the next year. We don't expect version changes to happen more often than quarterly.
- automoderator_rev_score: Actual number TDB: this will grow in tandem with the recent changes table per project. We are implementing a prune job to align retention with recent changes
Expected amount of queries, both writes and reads (per minute, per hour...per day, any of those are ok).
TODO
Examples of queries that will be using the table.
TODO
The release plan for the feature (are there specific wikis you'd like to test first etc).
We will be deploying to test and id.wiki first, aiming for May 2024.