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, Jan 8, 3:32 AM
Unknown Object (File)
Tue, Dec 31, 6:11 AM
Unknown Object (File)
Wed, Dec 25, 8:06 PM
Unknown Object (File)
Tue, Dec 24, 4:22 AM
Unknown Object (File)
Tue, Dec 17, 1:39 PM
Unknown Object (File)
Fri, Dec 13, 4:46 AM
Unknown Object (File)
Dec 11 2024, 8:24 AM
Unknown Object (File)
Dec 5 2024, 7:08 AM
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
Lint
Lint Not Applicable
Unit
Tests Not Applicable