lp:~wgrant/launchpad

Owned by William Grant
Get this repository:
git clone https://git.launchpad.net/~wgrant/launchpad
Only William Grant can upload to this repository. If you are William Grant please log in for upload directions.

Branches

Name Last Modified Last Commit
master 2022-02-09 16:31:22 UTC
Don't retry dep-wait builds for disabled DASes

Author: Colin Watson
Author Date: 2022-02-09 16:31:22 UTC

Don't retry dep-wait builds for disabled DASes

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

archive-file-history-refactor 2020-09-16 07:57:32 UTC
Experimental _updateByHash refactoring.

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

Experimental _updateByHash refactoring.

preflight-10s 2020-03-16 07:31:23 UTC
Wait longer in preflight.py for connections to die

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.

security.py-numeric-usernames 2020-03-05 15:08:37 UTC
Fix security.py to not crash on a role name with digits

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".

pg10-stattuple-perms 2020-02-28 06:57:15 UTC
Update security.cfg for PostgreSQL 10's pgstattuple

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.

bprdc-ios 2020-02-27 10:43:05 UTC
Index BinaryPackageReleaseDownloadCount for index-only scans

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.

optimise-gina 2019-12-21 00:22:47 UTC
Optimise gina source and binary DB lookups

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).

17 of 7 results
This repository contains Public information 
Everyone can see this information.

Subscribers