Homestyx hydra
Diffusion hydra 516aaad3410c

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

Description

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

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.

Maniphest Tasks: T11015

Differential Revision: https://secure.phabricator.com/D19185

Details

Provenance
epriestleyAuthored on Mar 6 2018, 11:25 PM
sirocylPushed on Oct 16 2024, 5:49 AM
Parents
R1:df1e9ce646c0: Treat Owners paths like "/src/backend" and "/src/backend/" identically
Branches
Unknown
Tags
Unknown

Event Timeline