lp:~wgrant/launchpad

Author: Colin Watson
Author Date: 2023-04-24 08:07:13 UTC

Include built assets in deployment tarballs

Merged from https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/441734

Author: William Grant
Author Date: 2020-09-16 07:57:32 UTC

Experimental _updateByHash refactoring.

Author: William Grant
Author Date: 2020-03-16 07:31:23 UTC

Wait longer in preflight.py for connections to die

Despite the comment saying it could wait for 10s, it in fact only waited
for up to 2s. This has for some time not been reliably sufficient, as
a rerun of full-update has often been necessary.

Author: William Grant
Author Date: 2020-03-05 15:08:37 UTC

Fix security.py to not crash on a role name with digits

PostgreSQL's aclitem putid emits role names unquoted in safe cases, but
security.py's regex didn't use the same safe set so failed to parse
ACLs involving usernames like "abc123".

Author: William Grant
Author Date: 2020-02-28 06:49:47 UTC

Update security.cfg for PostgreSQL 10's pgstattuple

Just eliminates security.py warnings.

Author: William Grant
Author Date: 2020-02-27 08:09:43 UTC

Index BinaryPackageReleaseDownloadCount for index-only scans

Creating an index on binarypackagereleasedownloadcount (archive,
binary_package_release, day, country, count) allows
BinaryPackagePublishingHistory.getDailyDownloadTotals,
Archive.getPackageDownloadCount and friends to execute as index-only
scans and not touch the heap at all. One sample query drops from 2789
page reads to 177.

Author: William Grant
Author Date: 2019-12-21 00:22:47 UTC

Optimise gina source and binary DB lookups

The relatively modern SourcePackagePublishingHistory.sourcepackagename
and BinaryPackagePublishingHistory.binarypackagename denormalised fields
can improve gina's plans by orders of magnitude in some cases.

This also fixes gina's binary handlers (not used on production since
2006) to correctly deal with multiple archives per distribution (it's
been incorrect since 2007's ArchiveRework).