Page MenuHomePhabricator

Use "pathIndex" in some owners package queries to improve query plans
ClosedPublic

Authored by epriestley on Mar 7 2018, 4:28 AM.
Tags
None
Referenced Files
Unknown Object (File)
Wed, May 1, 12:21 AM
Unknown Object (File)
Fri, Apr 19, 7:31 PM
Unknown Object (File)
Mar 31 2024, 4:58 AM
Unknown Object (File)
Mar 28 2024, 3:47 PM
Unknown Object (File)
Feb 12 2024, 9:54 PM
Unknown Object (File)
Feb 3 2024, 6:22 PM
Unknown Object (File)
Feb 2 2024, 11:22 PM
Unknown Object (File)
Dec 21 2023, 11:37 PM
Subscribers
None

Details

Summary

Depends on D19184. Ref T11015. Now that we have a digest index column, we can improve some of the queries a bit.

Test Plan
  • Ran queries from revision pages before and after with and without EXPLAIN.
  • Saw the same results with much better EXPLAIN plans.
  • Fragment size is now fixed at 12 bytes per fragment, so we can shove more of them in a single query.

Diff Detail

Repository
rP Phabricator
Branch
opath5
Lint
Lint Passed
Unit
Tests Passed
Build Status
Buildable 19760
Build 26768: Run Core Tests
Build 26767: arc lint + arc unit