lp:~wgrant/launchpad/+git/launchpad15

Owned by William Grant
Get this repository:
git clone https://git.launchpad.net/~wgrant/launchpad/+git/launchpad15
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
bprdc-ios 2020-02-27 10:43:05 UTC 2020-02-27
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.

11 of 1 result
This repository contains Public information 
Everyone can see this information.