Loading...

XML

Word

Printable

JSON

We're going to change 8.0 and master to use the classic plan cache instead of the SBE plan cache in release builds.

Under SBE full feature flag, we will continue to use the SBE plan cache so that we keep test coverage of it.

This ticket is broken into several sub-tasks. The parent-level ticket will be used for enabling the new code path.

causes

SERVER-91076 SBE with classic plan cache uses same plan cache key for queries with and without hints

has to be finished together with

SERVER-90417 Disable SBE for Time Series on 7.3

is depended on by

SERVER-89088 Time series queries do not use plan cache when query parameters are changed slightly

SERVER-89436 Multi-planning may be necessary more often in SBE than in classic

related to

SERVER-91095 Make cases where plan cache stores neither works nor reads more explicit

SERVER-90880 Cache single solution plans in classic cache for queries using SBE

(1 related to)

1.	Update classic plan cache key generation code to allow for SBE usage	SERVER-90490	Closed	Ian Boros	8.1.0-rc0, 8.0.0-rc5
2.	Make plan cache entries store "works type" explicitly	SERVER-90489	Closed	Ian Boros	8.1.0-rc0, 8.0.0-rc6
3.	Make classic plan cache support VirtualScan plans	SERVER-90492	Closed	Mihai Andrei	8.1.0-rc0, 8.0.0-rc5
4.	Change MultiPlanStage to write to plan cache via callback	SERVER-90494	Closed	David Storch	8.1.0-rc0, 8.0.0-rc6
5.	Ensure subplanning-eligible plans can use classic plan cache with SBE	SERVER-90493	Closed	David Storch	8.1.0-rc0, 8.0.0-rc6
6.	Refactor get_executor.cpp to accommodate an SBE-with-classic cache code path	SERVER-90491	Closed	Ian Boros	8.1.0-rc0, 8.0.0-rc6
7.	Improve caching VirtualScanNodes in classic plan cache along with testing	SERVER-90496	Open	Unassigned
8.	Review and investigate performance regressions in SBE plan cache disablement	SERVER-90521	Closed	Drew Paroski