launchpad-reviewers team mailing list archive

[Colin Watson <cjwatson@xxxxxxxxxxxxx>]

The proposal to merge lp:~cjwatson/launchpad/package-cache-drop-changelog into lp:launchpad has been updated.

Description changed to:

Stop populating DistributionSourcePackageCache.changelog, and make update-pkgcache depopulate it.

The changelog was first added here in https://bugs.launchpad.net/launchpad/+bug/48735, and it is at least considered only as a bottom-priority item.  But it doesn't make all that much sense, at least nowadays: we now have a pretty decent batched +changelog view, matching on changelog terms will often not be what you expected except in special-purpose circumstances, and general fishing expeditions are probably better handled by a general-purpose search engine.  The changelog makes up about half of the table size (166 of 341 MB on dogfood), so I'd like to trim it down so that we can make the package cache quicker to update and easier to use for source package vocabulary pickers.

The next step will be to drop the column from the database, but we need this on production first to rebuild the fti column.

For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/package-cache-drop-changelog/+merge/294894
-- 
Your team Launchpad code reviewers is subscribed to branch lp:launchpad.