Page MenuHomePhabricator

Remove a couple of unused, unneeded pagetriage_page_tags
Open, Needs TriagePublic

Description

I noticed that for redirects, for example, there are rows in the pagetriage_page_tags table for category count, citation count, and even AfC state. This information is not exposed in the interface for redirects because they aren't applicable, hence we probably shouldn't store them in the first place. Similarly drafts and user pages shouldn't have category count, etc.

It is worth noting that the values for these specific tags are small integers, but they are stored as a VARBINARY (ptrpt_value).

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
MusikAnimal renamed this task from Don't create rows in pagetriage_page_tag unless you have to to Don't create pagetriage_page_tags unless we need to.Jul 25 2019, 2:19 AM
MusikAnimal updated the task description. (Show Details)
kostajh moved this task from Inbox to Triaged but Future on the Growth-Team board.
kostajh subscribed.

Thanks for filing this. Seems worth addressing, but not something Growth-Team will work on in the short-to-medium term.

Novem_Linguae renamed this task from Don't create pagetriage_page_tags unless we need to to Remove a couple of unused, unneeded pagetriage_page_tags.Oct 30 2025, 6:29 PM
Novem_Linguae reopened this task as Open.
Novem_Linguae subscribed.

This feels like a different task than T406177. I think this one is advocating removing a couple of unused tags, rather than advocating for moving where all tags are stored.