Cleaning out archived patches

Konstantin Ryabitsev konstantin at linuxfoundation.org
Thu Oct 29 23:25:48 AEDT 2020


Hi, all:

One way to slim down the DB size would be to turn archived patches into 
a simple mapping of patchid/msgid to the archival URL. A request to an 
archived patch would then be a simple redirect to the archival site, 
e.g.:

https://patchwork.kernel.org/patch/11865643 
 -> https://lore.kernel.org/r/a90452e4fe7c6064026edc8377debd456f54137d.1603944740.git.pavana.sharma@digi.com

Similarly,

https://patchwork.kernel.org/project/netdevbpf/patch/a90452e4fe7c6064026edc8377debd456f54137d.1603944740.git.pavana.sharma@digi.com/
 -> https://lore.kernel.org/r/a90452e4fe7c6064026edc8377debd456f54137d.1603944740.git.pavana.sharma@digi.com

The table of archived patches would simply be:

patch_id | proj_name | msgid    | archive_url
11865643 | netdevbpf | a9045... | https://lore.kernel.org/...

None of the above values would be foreign keys, which would allow 
cleaning up old patches and old projects without breaking links.

This should help dramatically reduce the number of rows involved in most 
operations.

What do you think?

-K


More information about the Patchwork mailing list